Greetings Vim Experts!
I'm using gVim on windows 10, and installing the plugin vim-dadbod to work with Azure SQL (SQL Server). I believe the plugin is installed correctly as I see the connection string being turned into a SQLCMD in a pop-up window. The final command that vim-dadbod creates is using single quotes for all of the parameters & I think that is what is wrong. If I type out the same SQLCMD without the quotes (in a CMD window), it works. Has anyone had similar issues using vim-dadbod with SQL Server?
The manual connection string that works from a CMD window is:
sqlcmd -S SERVERNAME.database.windows.net -U USERNAME -d DBNAME -q "select name from sys.tables"
The command (copied from a screenshot) being generated from vim-dadbod is:
cmd.exe /c (^(sqlcmd -S 'SERVERNAME.database.windows.net' -U 'USERNAME' -P 'PASSWORD' -d 'DBNAME'^) ^< C:/Users/USERNAME/AppData/Local/Temp/VIiF7B1.tmp ^>C:/Users/USERNAME/AppData/Local/Temp/VIoF7B2.tmp 2^>^&1)
I assume the tmp files are for the actual query and returned results, but that's just a guess.