Possible 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. No
w
i am getting the following error, which i believe is related to a timeout, a
s
i can transfer in the region of 3-4000 records before the error occurs. Is i
t
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 serv
er 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};"
Have at various time added the following "ConnectionTimeout=100000" in an
attempt to solve the problem, but this doesn't seem to help.
Would appreciate any helpfull suggestions.
Mike55.You could run a profiler trace, and check for 'Attention' events. When you
get this error, can you open a command prompt and ping the machine on which
the SQL Server resides? If you run into errors then, sounds like it's
network load related.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.