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.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Connection Pooling is managed by the Oracle Client/Server. CR has no control over it. If we can though we do disconnect, if the Client/Server does not allow use to send a full disconnect we can't force it to except when using our Native Driver.

If you use CR's native Oracle Driver it should not pool the connection and I believe using ODBC also disconnects the connection and does not use Pooling but that may depend on the ODBC driver used.

Check with your DBA and refer to Oracles help file on how to manage connection pooling.

Don

0 Kudos

Thanks for the reply Don, Is there is any way to pass an oracle connection object to the report instead of ConnectionInfo

0 Kudos

Can you select it in CR Designer? If not then no.

Don

Answers (1)

Answers (1)

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