I'm using RDO to access data from a SQL server 6.5, when I try to run a Select on a table wich have about 390,000 records I get this error message : S1T00: [Microsoft][ODBC SQL Server Driver] Timeout expired
What can I do to solve this problem ??
Thanks,
Fri, 25 May 2001 03:00:00 GMT
William A. Kilgor #2 / 2
Timeout Expired Error With SQL server ODBC
I had the same problem until I manipulated the odbc.timeout setting...
Dim dbsCurrent As Database Set dbsCurrent = OpenDatabase("Northwind.mdb") dbsCurrent.QueryTimeout = 30
Try it....
Quote:
> I'm using RDO to access data from a SQL server 6.5, when I try to run a > Select on a table wich have about 390,000 records I get this error message > : > S1T00: [Microsoft][ODBC SQL Server Driver] Timeout expired
Timeout Expired Error With SQL server ODBC