What are the challenges you face when working across database platforms? Take the survey

SQL Compare error

dbelldbell Posts: 5
edited November 28, 2005 10:21AM in SQL Compare Previous Versions
When I attempt to compare I get the message:
Cant load xplog70.dll or one of its references reason 193(error not found)

I think is happened due to a security update from MS, but I can't figure out which one. Has anyone else encountered this? Any help would be appreciated.

Note I have reinstalled SQL compare both as a repair and a full install.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    Xplog70.dll contains extended stored procedures that ADO .net (and in turn SQL Compare) need to have available to run SQL queries.

    I don't have a solution that I can recommend for this problem, but what has worked in the past is to get an older copy of xplog70.dll and copy it over the newer one.

    The person that I'm talking about had xplog70.dll version 2000.80.760.0 and replaced it with version 2000.80.194.0.

    I don't recommend replacing the dll, though! I'd re-run the latest SQL service pack setup first.
  • Options

    SQL Compare uses the extended stored procedure xp_msver, which resides in xplog70.dll, to get server information before a compare. Since this has given us so much grief, we'll use a different method to get the server version in a future release of SQL Compare.
  • Options
    @VERSION. This has prevented this problem from happening again since.
This discussion has been closed.