Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Increase or eliminate OLE DB SQL Timeout
Message
 
To
19/01/2007 21:08:09
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01187290
Message ID:
01187629
Views:
13
The ADO connection object has a property called Commandtimeout, the default value for this property is 30 seconds but you can set it to whatever value you want.

HTH,

Enmanuel

>Hi All,
>
>I am calling a delete stored procedure that runs super long from VFP and am getting a SQL Timeout error.
>
>How do I lengthen or eliminate the OLE DB SQL Timeout?
>
>Aloha,
>
>James
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Previous
Reply
Map
View

Click here to load this message in the networking platform