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,

 

What version of enterprise gateway you used? AFAIK, it only open one active session to handle refresh operation even if refresh operation triggered many times.

 

Regards,

Xiaoxin Sheng

  • ataft's avatar
    ataft
    Icon for Advocate I rankAdvocate I
    8 years ago
    14.16.6745.2
    • 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.