Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2004

    Unanswered: Connecting to SQL Server (sqlsrv32.dll)


    I am having problem with our network. We run a clinic database system that uses SQLServer 2000 Enterprise as the backend, and Microsoft Access on the front end.

    I have had a running problem with all our newer machines (which run Windows 2000 or XP) in that while it connects to the server and retrieves some of the info properly, on some of the pages it doesnt. It will take 2 or 3 minutes for a page of the database to load, and even then not all the information will be retrieved properly.

    I was able to fix the problem on the Windows 2000 machines by replacing the Sqlsrv32.dll file with an older version (usually with And then the W2000 machines would work. But for some reason, the XP machines wont accept the older sqlsrv32.dll gives me this error:
    SQLState: 'HY000'
    SQL Server Error: 126 Unable to load communication module driver correctly.

    ....and i cant seem to downgrade the MDAC....

    any ideas on what I can do?

    Last edited by desimaj; 10-14-04 at 11:58.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts