Although an Oracle DSN supports timeouts (which can be disabled
via a checkbox), creating a DSN-less connection in VB6 will not respect
any settings for the Connection.ConnectionTimeout or
Command.CommandTimeout settings. It just ignores them and your
application will sit and wait until the request is done.
See MDSN article ID: 251248
http://support.microsoft.com/default.aspx?scid=kb;en-us;251248
The Microsoft Oracle ODBC driver and Microsoft OLE DB Provider for Oracle do not support setting connection timeouts or query timeouts.
There is no workaround to allow setting a query timeout.
For connection timeouts you can work around the issue, if your database application framework supports asynchronous operations. By putting the call to open the connection in an asynchronous loop and checking the status of the connection, you can terminate the connection if it does not occur in the stated duration of time. The implementation of this solution is application-dependent, but an example using ActiveX Data Objects (ADO) is shown in the "More Information" section of this article.