Trying to connect to a MS SQL Server Instance using sqlcmd.exe and got the error message below:
Sqlcmd: Error: Connection failure. SQL Native Client is not installed correctly.
Of course, Googled and discovered that it is probably a Windows Path issue (manifested by the system picking up a wrong \ mismatched dll).
Errors such as this is common in cases where multiple SQL Server Binaries are loaded on the system.
As a work-around:
- Review and correct your path
- Transverse to the folder that contains the version of the sqlcmd that you want and run sqlcmd from that folder
- Un-installed previous Microsoft SQL Server Client