PC Review


Reply
Thread Tools Rate Thread

Connection pooling parameters not working for Oracle connection

 
 
yoram.ayalon@structuredweb.com
Guest
Posts: n/a
 
      29th Sep 2006
I am using OracleConnection to connect to Oracle 9i Database from a
VB.NET project the connection string has the parameters "User ID",
"password", and "Data Source". my project import
System.Data.OracleClient

I tried to add connection pooling parameters like "Connection Timeout",
"Incr Pool Size" and "Min Pool Size" to the connection string string
but for each one I get the error that this parameters is not supported,
when I try to open the connection

any clue ?

 
Reply With Quote
 
 
 
 
William \(Bill\) Vaughn
Guest
Posts: n/a
 
      29th Sep 2006
While I don't profess to be an Oracle expert, I do know that each provider
implements pooling in its own way. I would not be surprised if the Oracle
provider used different ConnectionString keys or did not support pool
configuration. I would try the new ConnectionStringBuilder class...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using OracleConnection to connect to Oracle 9i Database from a
> VB.NET project the connection string has the parameters "User ID",
> "password", and "Data Source". my project import
> System.Data.OracleClient
>
> I tried to add connection pooling parameters like "Connection Timeout",
> "Incr Pool Size" and "Min Pool Size" to the connection string string
> but for each one I get the error that this parameters is not supported,
> when I try to open the connection
>
> any clue ?
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle connection pooling Lenny Shprekher Microsoft ADO .NET 3 10th Dec 2004 01:49 PM
Oracle Connection Pooling Problem Basharat Ali via .NET 247 Microsoft ADO .NET 0 6th Sep 2004 08:00 AM
Oracle Connection Pooling Jim Heavey Microsoft ADO .NET 2 1st Jun 2004 02:38 PM
Oracle 9.2.0.4 connection pooling problem Paul Speranza Microsoft ADO .NET 9 24th Apr 2004 12:23 PM
Connection pooling in Oracle Eka Gautama Microsoft ADO .NET 3 30th Sep 2003 12:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:18 PM.