Access2000 to SQLServer2000 on an XP Nachine (sqlsrv32.dll)

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

From: desimaj (desimaj_at_discussions.microsoft.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 11:31:04 -0700

I am having a problem connecting to my SQL server.

I am try to connect to a MS-SQL Server 2000 (database) through Access 2000
(frontend of database) on our only XP machine. All my NT machines connect
easily, with no problems. A handful of Windows 2000 machines used to give me
problem, but if i would replace the SQLSRV32.DLL with a copy from the NT
machines it would work ok.

BUT on the XP, when i replace the sqlsrv32.dll, i cant make the ODBC
connection. it gives me the errors:

Connection Failed
SQLState: 08001
SQL Server Error: 0
[microsoft][odbc SQL Server Driver] Client unable to establish connection
Connection Failed
SQLState: HY000
SQL Server Error: 126
[microsoft][odbc SQL Server Driver] Unabale to load communication model.
driver has not been correctly installed.

how do get these old sqlsrv32.dll to work on my XP machine?

BTW, the problem with the regular or newer MDAC or sqlsrv32.dll is that i
can connect to the databse from access, but only sopme of the fields show up,
and some dont. i think i would have to do an overhaul of the access frontend
and the sql tyables to fix that....and thats not an option right now....

Please suggest.

Relevant Pages

  • Connecting to SQL Server (sqlsrv32.dll)
    ... I am having a problem connecting to my SQL server. ... A handful of Windows 2000 machines used to give me ... Connection Failed ... i think i would have to do an overhaul of the access frontend ...
    (microsoft.public.data.odbc)
  • Re: Speed up of connection to SQL Sever from VB.NET
    ... Are the connection strings same on the two machines? ... > I am running a tiny SQL Server 2000 database on a Small Business ... > logins) to it from 2 XP professional workstations each running the same ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting To SQL Server Running on Peer to Peer Workgroup.
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... I even tried turning the Windows firewall off completely on both ... > The two machines are connected by a switch and they are on IP Addresses ... > internet connection or DHCP server it's just a very simple hard coded 2 ...
    (microsoft.public.sqlserver.connect)
  • Re: Connection failure on standalone MSDE installtion when network is lost
    ... Check local security policies on client machines that screw up. ... > On a standalone installation i.e client and SQL server are on same ... > connection through client application, then SQL connection could not be ...
    (microsoft.public.sqlserver.connect)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)