Hi,<br>I'm having some problems dealing with queries that give me some kind of error message : 'Microsoft ODBC SQL Server Driver Timeout Expired'. Can anyone please tell me how to increase that timeout ?
You can go to Window's ODBC manager under Control Panel and choose the SQL Server driver; the query timeout parameter is one of the last screens in the configuration wizard-type interface (i.e., keep hitting the Next button). <p>Robert Bradley<br><a href=mailto: > </a><br><a href=
May I know which platform are you refering to ? I cannot find it in Win95.
Does changing the driver from sql driver to oledb driver help to solve the timeout ?
I no longer have access to the machine on which I was running this, and I don't see it on my Win2K machine at present. What client are you using to run the queries (i.e. Query Analyzer, VB/ADO, VFP)? Robert Bradley
Actually, I am using VB/ADO to write a schedule job to run on the NT server with SQL server database. The timeout expired happen when trying to execute an Insert statement which has a select statement i.e. "Insert into table1 select column1, column2 from table2".
I have tried to increase the time for connection timeout property of the ADO connnection, but still face the same problem. Will it help if I increase the time for command timeout property or if I change the connection string to be using SQL OLEDB provider instead of SQL driver ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.