Timeout error

10-20-2004, 04:40 AM
Hi all,

Am basically doing a select star on a collection of tables in Access tables, the data that i select is then taken and put into an SQL server database. Now i am getting the following error, which i believe is related to a timeout, as i can transfer in the region of 3-4000 records before the error occurs. Is it possible in the connection string to my sql database to specify a minimum timeout time??

Here is the error:
-2147467259[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist or access denied

Here is my connection string:

Set gcnMartConnect = New ADODB.Connection

'Open a connection with the Marts SQL Server Database
gcnMartConnect.Open "UID=;pwd=;Database=Marts;" & _
"Server=localhost;Driver={SQL Server};"

10-20-2004, 05:35 PM
Can we see more of your code? You can set the default .ConnectionTimeout property to a higher value, which might help your situation. And, you might want to use a serverside cursor for your sql server connection.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum