How to set Oracle Stored Procedure Timeout

jcslam · #1 (**permalink**) October 18th, 2004, 03:38 AM

Dear all,

In and using VB 6.0 ADO connect to Oracle DB Server. I know the ADO Command has Timeout property that limit the time to execute a query.
I try this property work when I use "Microsoft ODBC for Oracle" connection method. But it does not work when I use "Microsoft OLEDB for Oracle" and "Oracle OLEDB" connection methods.

Does any one know is that property really support "ODBC" connection only? If so, how to set the timeout value in running oracle stored procedure?

Regards,
Joe

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
.net with oracle stored procedure	vgsgowrisankar	C# 2005	1	April 16th, 2008 03:14 PM
Oracle Stored Procedure	life.gurpreet	C# 2005	0	March 13th, 2007 04:54 AM
Running oracle stored procedure from access	Justine	Access	9	December 21st, 2006 09:36 AM
Calling an Oracle Stored Procedure	booksnore2	BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7	2	October 1st, 2004 09:35 AM
arrays and stored procedure in oracle	Munawwar	Oracle	1	March 12th, 2004 04:34 AM