Timeout error

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};"

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.