Trying to get an MS SQL Server Build System going.
{
"cmd": "SQLCMD.EXE", "-U", "my_user", "-P", "P@s$1W0rd", "-S", "DBSERVERNAME", "-d", "databasename", "-q", "'select * from myTable'"]
, "selector": "source.sql"
}
This is what I have so far, but it gives me this error:
Error: Microsoft SQL Server Native Client 11.0 : Login failed for user ‘my_user’…
But I know the user creds, server, and database name are correct, because I can run this in a Windows batch file and it works:
start SQLCMD.EXE -U my_user -P P@s$1W0rd -S DBSERVERNAME -d databasename -q "select * from myTable"(Of course, I have substituted dummy credentials, however, the same special characters are in the dummy password as are in the real one. I’m wondering if any need to be escaped somehow)
Thank you for any help, and I was surprised not to be able to find any examples of MS SQL Build Systems online or in these forums.