I'm connecting to our Oracle database using the connection string below:"Provider = MSDAORA.1;User ID=****;Password=****;Data Source=****;Extended Properties=;Persist Security Info=False;"I'm now trying to get connection pooling working on this
connection, to no avail. My googling has resulted in my thinking that setting the max pool size is not available for OLEDB connections (using MSDAORA): all I can do is turn it on or off. Would this be right? There's no way to set the size of pool? Anyone know
what the default size is? 100?
Just as a further note, while we're happy that pooling is automatically on via the OLEDB provider, if there are too many concurrent users, at some point, we're going to exceed our maximum processes setting (50). We can avoid this is we can set it to Max Pool
Size +1, but we need to know what the default Max Pool Size is.
None
0 Points
60 Posts
Connection pooling with the OLEDB driver
Jun 09, 2004 01:27 PM|mpgalvin|LINK
"Provider = MSDAORA.1;User ID=****;Password=****;Data Source=****;Extended Properties=;Persist Security Info=False;"I'm now trying to get connection pooling working on this connection, to no avail. My googling has resulted in my thinking that setting the max pool size is not available for OLEDB connections (using MSDAORA): all I can do is turn it on or off. Would this be right? There's no way to set the size of pool? Anyone know what the default size is? 100?None
0 Points
60 Posts
Re: Connection pooling with the OLEDB driver
Jun 10, 2004 06:12 AM|mpgalvin|LINK
None
0 Points
1 Post
Re: Connection pooling with the OLEDB driver
Apr 25, 2010 12:01 PM|erikiscool|LINK
Did you ever find a resolution? I am having the same issue with MSDAORA and don't want to rewrite my code to use another type of connection