How can we help you today? How can we help you today?

SQLite error when running from SSMS

If I try initiate a compare through SSMS using source control, I get the error : "Cannot load the Backup Reader dll - Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found."

If I then open SQL Compare itself and do the same compare, it works.

Anybody know how to solve this problem?
mika76
0

Comments

4 comments

  • Eddie D
    Thank you for your forum post and sorry that you have encountered a problem.

    The two most common causes of the error - Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found - is either a corrupt installer (or outdated integration pack), or an anti-virus programming quarantining (or completing deleting) the 'SQLite.Interop.dll'.

    the first troubleshooting steps that I would like for you to try:
    • Go to Control Panel > Programs & Features, sort by "Publisher" and delete all Red Gate tools.
    • Disable any anti-virus program(s) temporarily (please let me know if you are unable to do this)
    • Download a fresh installer from our website:http://www.red-gate.com/dynamic/products/sql-development/sql-developer-bundle/download (choose the "Already a customer" option)
    • Right-click on the installer icon, and choose "Run as Administrator".
    • Go through the wizard and choose all of the tools you're entitled to (make sure you choose the "SSMS Integration Pack)
    • Lastly, try running the tool to see if it works.
    Please let me know how this works out for you.

    Many Thanks
    Eddie
    Eddie D
    0
  • mika76
    Hi Eddie,

    Nope - tried on a totally new VM installed everything from scratch - still the same problem. If I try to compare straight from SSMS I get the Sqlite error.
    mika76
    0
  • Eddie D
    Thank you for your reply and sorry that the repair instructions did not workout for you.

    I have added the details of this to a bug report whose reference is SC-6673. Can you please continue to launch SQL Compare from the Start menu outside of SSMS until we get this bug resolved.

    Many Thanks
    Eddie
    Eddie D
    0
  • Eddie D
    Hi

    Thank you for your patience. Bug SC-6673 is now fixed in SQL Compare V11. Please use this LINK to download SQL Compare V11.1.3.30.

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.