Overview
Are you getting an error -2147467259 when trying to initialize the Sqlcmd Library? This guide will provide you with a troubleshooting approach towards fixing the issue so that you can access the Sqlcmd Library without any trouble.
Diagnosing the Error
Error -2147467259 is a COM error with a message Automation error Library not registered. This error typically occurs when the program being run is referencing an outdated version of the Sqlcmd Library. The easiest way to determine the cause of the issue is to check the registry.
Resolving the Error
The first step is to create a registry backup & then proceed to delete any registry entries related to the Sqlcmd Library.
Create a registry backup: Open the registry editor & make a backup of the current registry database. This is important as a backup will ensure that you can restore the database in case something goes wrong during the process.
Then delete the registry entries: This step requires you to open the registry editor & remove any entries related to the Sqlcmd Library. Check for the following values in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ORACLE\SQLCMD\1.0.0HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\OraOMF\1.0HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\sqldc.exe
Reinstall the Sqlcmd Library: After deleting the registry entries, you need to reinstall the Sqlcmd Library. This can be done by downloading the latest version of the library from the Microsoft Download Center.
Run the repaired install: After downloading and installing the library, you should run the repaired install in order to fully utilize the library.
FAQ
Q: What is the error -2147467259?
A: Error -2147467259 is a COM error with a message Automation error Library not registered.
Q: How can I resolve the Issue?
A: The best way to resolve the error is to create a registry backup & then delete any registry entries related to the Sqlcmd Library. After that, you can reinstall the Sqlcmd Library & then run the repaired install.