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 Files\Microsoft SQL Server\110\Tools\Binn
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:\\.\pipe\LOCALDB#F8040C8F\tsql\query
.
sqlcmd -S (localdb)\Projects -Q "SELECT DB_NAME(), @@SERVERNAME;"
. Essentially, unless something else is missing, LocalDB connections (as of .NET Framework v 4.5, I believe) are made using "(localdb)\{InstanceName}". If that works, I will add it as an answer.