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.