Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    5

    Unanswered: Connecting to SQLServer 2000 (sqlsrv32.dll)

    Hello,

    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 3.70.06.23). And then the W2000 machines would work. But for some reason, the XP machines wont accept the older sqlsrv32.dll file...it 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?

    thanks
    Last edited by desimaj; 10-14-04 at 12:59.

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    You didnt test it properly before it was rolled out for XP, did you?

    Tut tut.....

    Best check technet & see if there is a work around. Failing that, best roll XP boxes back to W2000. Quick, easy & saves face.....then I'd spend a LOT of time ironing out the XP issue BEFORE it goes near the client again.



    HTH,

    Cheers,

  3. #3
    Join Date
    Oct 2004
    Posts
    5
    no they are the new computers we got in...they come with XP loaded on them already....

    i'll check technet....and then possibly put W2K on them....

    thanks...

Posting Permissions

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