cancel
Showing results for 
Search instead for 
Did you mean: 

connection pooling with Oracle using c#.NET

0 Kudos

We are seeking your help to manage the pooling of the connection of the crystal report to oracle db using SAP crystal report for visual studio.

View Entire Topic
0 Kudos

but why the connection to DB not closed and still inactive even if we called report.close and report.dispose. This why we are seeks to disable the pooling but if we could kill the inactive database sessions. it will be sufficient. 

0 Kudos

Hello,

It's not CR doing the pooling, We send a close but due to the client/Server it keeps the connection valid for some other process to use.

Check with your DBA on how to configure the Server/Client to not use Connection Pooling.

See if this KBA works for: https://i7p.wdf.sap.corp/sap/support/notes/2107357

Note the end of the info, there is an option to pass to the Client that may work for you.

Don


former_member183750
Active Contributor
0 Kudos

Just wanted to provide SCN link to the KBA Don recommended:

2107357 - Windows.Form Viewer does not disconnect from the Database when the viewer object is close/...

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter