cancel
Showing results for 
Search instead for 
Did you mean: 

connection pooling with Oracle using c#.NET

0 Kudos
232

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

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