SQL Compare error
dbell
Posts: 5
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.
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.
This discussion has been closed.
Comments
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.
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.