Oracle Connection Timeout

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
scott.pedersen
Posts: 21
Joined: Tue 06 Jun 2006 03:14
Location: Auckland, New Zealand

Oracle Connection Timeout

Post by scott.pedersen » Mon 14 Aug 2006 04:51

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.

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 14 Aug 2006 06:49

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.

Post Reply