Linked Tables - ODBC SQL Server Driver Timeout Expired

Tech-Archive recommends: Fix windows errors by optimizing your registry

Environment: Access 2003 front-end, SQL Server 2005 back-end with a named
instance.

I need to use the SQL Server driver instead of the Native Client driver when
linking the table since the former is not available in all our pc's. On the
first attempt to open one of these linked tables, I get the SQL Server Driver
Timeout Expired error. But if I immediately try to open the table a second
time, the error goes away and I can connect to the table. The same error
occurs even for tables with only 1 record. (Note: the Native Client driver
works, but it is difficult to distribute the driver to the client pc's since
our pc's are in a locked down evironment.)

Is there some setting that I need to change? Is there a way to trap this
error, perhaps in a table linking code? Am I beating a dead horse? I have
spent days researching/testing and nothing has fixed this error. Missed my
deliverable date :( Thanks in advance for any assistance.
.

Relevant Pages

  • MSSQL Server ODBC driver crash
    ... If the SQL Server driver's option "Use ANSI nulls, paddings and warnings" ... is not set and the length of char is over 623, MS SQL Server driver will ...
    (microsoft.public.data.odbc)
  • MS SQL Server 2000 ODBC driver crash
    ... If the SQL Server driver's option "Use ANSI nulls, paddings and warnings" ... is not set and the length of char is over 623, MS SQL Server driver will ...
    (microsoft.public.data.odbc)
  • Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
    ... I am unsure why the code does not insert CR\LF as I am 100% sure the file itself contains CR\LF. ... At 24000 chrs it works and at 48000 chrs you lose each \ followed by a. ... It is of no consolation to you but I have duplicated it with the MS SQL Server driver and also demonstrated it works fine with our sql server driver. ...
    (perl.dbi.users)
  • Re: Old SQL ODBC driver on 2003 Server
    ... Try installing the latest MDAC ... > I have a Windows 2003 Server which has a very old sql Server ODBC Driver ... If I go into Data Sources and view the SQL Server driver it is ...
    (microsoft.public.sqlserver.odbc)
  • RE: Linked Tables - ODBC SQL Server Driver Timeout Expired
    ... "REC" wrote: ... I need to use the SQL Server driver instead of the Native Client driver when ... linking the table since the former is not available in all our pc's. ... first attempt to open one of these linked tables, I get the SQL Server Driver ...
    (microsoft.public.sqlserver.odbc)