Question :
On a machine with SQL Server LocalDB 2014 installed I am looking for SQLCMD.EXE file but cannot find it anywhere. Is there a way how to install it separately?
Unfortunately I am not local admin of the machine, so I prefer no MSI…
Found this link https://www.microsoft.com/en-us/download/confirmation.aspx?id=36433, but cannot use MSI… Perhaps copying executable files and dlls can do the trick.
After copying files SQLCMD.EXE, BATCHPARSER.DLL and SQLCMD.RLL from C:Program FilesMicrosoft SQL Server110ToolsBinn from another computer with SSMS installed I still get the error:
Microsoft SQL Server Native Client 11.0 : Data source name not found
and no default driver specified.
running sqlcmd -S np:\.pipeLOCALDB#F8040C8Ftsqlquery.
Answer :
I have figured out that during SQL Server LocalDB MSI installation the ODBC driver is not installed
So to use SQLCMD it is necessary to install
Microsoft® ODBC Driver 11 for SQL Server® – it is a part of ODBC driver as per here.
When I tried to install Microsoft® Command Line Utilities 11 for SQL Server® it prompted me to install the ODBC Driver first.
Then it is possible either to copy the files SQLCMD.EXE, BATCHPARSER.DLL and SQLCMD.RLL or to install Microsoft® Command Line Utilities 11 for SQL Server®.
Are you installing SQL Server 2014 on a Windows installation with no previous version of SQL Server in?
Have a look at C:Program FilesMicrosoft SQL ServerClient SDKODBC110ToolsBinn