Page 1 of 1

Oracle Connection Timeout

Posted: Mon 14 Aug 2006 04:51
by scott.pedersen
Hi,

I am running a stored procedure that is called using OraDirect and after about 30 seconds the connection times out.

Is there a way that I can specify a longer timeout period? I am using the OracleConnection class that doesn't allow the changing of the ConnectionTimout.

Cheers,

Scott.

Posted: Mon 14 Aug 2006 06:49
by Paul
This problem can happen if Direct=true only. You can set OracleCommand1.CommandTimeout=0 for specifying no limit to the wait time.
See DbCommandBase.CommandTimeout Property in Oradirect .NET documentation.