Click to See Complete Forum and Search --> : How to set CommandTimeOut in connectionstring using oracle Provider.


kvgujrathi
November 19th, 2007, 11:50 AM
Hello All,

How to set CommandTimeOut in connectionstring using oracle Provider.

Is there any way to set the commandtimeout in the following connectionstring ?

Open "Provider=OraOLEDB.Oracle;
Data Source=MyOracleDB;
User Id=/;
Password=;"

I know that commandtimeout works with DSN and if we dont use Provider.
But instead of the DSN how we can use it.

Thanks

Kamlesh Gujarathi.
kamlesh.gujarathi@yahoo.com.