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

From: Brannon Jones (brannonjNOSPAM_at_gmail.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 14:54:00 -0700

This is absolutely not supported.

sqlsrv32.dll is part of MDAC. You need to use it with the correct version
of MDAC. On XP, that's MDAC 2.7.

Brannon

"desimaj" <desimaj@discussions.microsoft.com> wrote in message
news:13A1620C-37D7-47D8-9BBC-86B0CCA5457D@microsoft.com...
> 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

  • Re: Delphi 7, TAdoConnection, Windows 2003 SP 1, MSDart.dll
    ... >> either a corrupted or incomplete or bad version of MDAC. ... >> The machines that I was dealing with happened to be xp machines which ... >> configuration and they had to do it. ... >>> Stefan Westner ...
    (borland.public.delphi.database.ado)
  • Re: How to revert from MDAC 2.8 to 2.7?
    ... That article, which point to the rollback, should work with MDAC 2.8 as ... > All of the machines are of identical hardware configurations, same OS, ... > And the MDAC install docs state that installing an older version will not ...
    (microsoft.public.data.ado)
  • Re: General Network Error
    ... It can be caused by different things but I've seen MDAC ... SQLState: ?01000? ... SQL Server Error: 11 ...
    (microsoft.public.sqlserver.connect)
  • Re: MDAC
    ... before installing the latest version of MDAC it didn't connect and give ... this is the first time it is happening to me. ... are reluctant to install the latest version of MDAC in all the machines ...
    (comp.databases.ms-access)
  • Re: Failure to open database
    ... There were problems at the same place on Win9x machines ... >about a year ago & that is when I learned about the MDAC versions. ... Could the MDAC(of your customer's WinXP SP2 ... customer to refresh the MDAC: ...
    (microsoft.public.vc.database)
Loading