DirectMode Connecting Pooling

kevin.weir · Post by **kevin.weir** » Wed 27 Apr 2011 17:54

We are using version 6.10.121 of dotConnect for Oracle that targets Oracle 10.2.0.4.

The following connection string is used in a Windows Form application:
User Id=USER;Password=PASSWORD;Server=DATABASE;Service Name=DATABASE;Direct=True;Pooling=true;min pool size=25;max pool size=125;

The problem we are having is 25 connections are created for each client that runs. Am I missing something? Isn't the whole point of connection pooling to share the connections among all the clients?

Kevin

Shalex · Post by **Shalex** » Thu 28 Apr 2011 14:48

Connection pool created by ADO.NET provider exists in the scope of current application domain: http://msdn.microsoft.com/ru-ru/library ... 85%29.aspx.
If you want to implement server-side connection pooling, please take a look at Oracle Database Resident Connection Pooling (DRCP). This feature is implemented in Oracle server 11g and supported by dotConnect for Oracle (available only in the OCI mode) starting from the 6.10.96 version.

kevin.weir · Post by **kevin.weir** » Fri 29 Apr 2011 16:56

Thanks for quick reply. That was helpful.