asp.net TO oracle timeout

[level1]

does anybody know how to set the timeout command when connection from ASP.NET to otacle? using

Dim oracleConn As OracleConnection = New OracleConnection
oracleConn.ConnectionString = "user id=xxx;data source=xxx;password=xxx;"

i tired connect timeout=9999 and connection timeout=9999 but both dont work...

 

[cappmgr]

Might help,

http://aspalliance.com/articleViewer.aspx?aId=560&pId=4

Marty

 

[level1]

Thanks cappmgr, although the article u are giving me suggest using: Imports Oracle.DataAccess.Client while i am using: System.Data.OracleClient. And thus the property Connection Timeout=60; is not supported, im getting: Keyword not supported: 'connection timeout'.

So i assume i have to download the ODP.NET which looks more poewrfull. Am i right?

 

[cappmgr]

.Net Framework Data Provider for Oracle is supposed to be the fastest. I have never bench marked so I am believing what I read. I am not sure how to set your timeout.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp

Marty

 

[level1]

Note Unlike the Connection object in the other .NET Framework data providers (SQL Server, OLE DB, and ODBC), OracleConnection does not support a ConnectionTimeout property. Setting a connection timeout using a property or in the connection string has no effect and value returned is always zero. OracleConnection also does not support a Database property or a ChangeDatabase method.

http://msdn.microsoft.com/library/d...racleConnectionClassConnectionStringTopic.asp

Thanks mate.