Forum Discussion

ataft's avatar
ataft
Icon for Advocate I rankAdvocate I
8 years ago
Solved

when refreshing report the database connection stays open causing multiple open connections

I have setup a SQL Server database connection using the enterprise data gateway. The connection is good and refreshes the data just fine.   The problem is that each time a refresh happens, schedule...
  • ataft's avatar
    ataft
    8 years ago

    Thanks for asking questions on this issue! This must have been an anomoly of some kind. I have not been able to reproduce the problem. The past few days I've done everything to try to cause the problem and it doesn't happen.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi ataft,

 

Can you please use SQL Server Profiler to trace more detailed information and share here to help us clarify your scenario?

SQL Server Profiler

 

Regards,

Xiaoxin Sheng

ataft's avatar
ataft
Icon for Advocate I rankAdvocate I
8 years ago

Thanks for asking questions on this issue! This must have been an anomoly of some kind. I have not been able to reproduce the problem. The past few days I've done everything to try to cause the problem and it doesn't happen.