"Mike55" <Mike55@discussions.microsoft.com> wrote in message
news:43D94B76-5DCB-427A-B1D1-0B4763A5F78F@microsoft.com...
> 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};"
>
> Have added at various times "Connectiontimeout = 100000;" but this seems
to
> be of no help. Would appreciate it if someone could make some
suggestions.
>
> Mike55