vim-dadbod
vim-dadbod copied to clipboard
MS SQL Server adapter -U/-P flags passed in SQL Server connection string
vim.g.dbs = {
{
name = "DEV",
url = "sqlserver://HOSTNAME:1433/DBNAME",
},
}
Connecting to db DEV...
Error detected while processing function <SNR>38_method[2]..43[30]..46[7]..17[16]..function <SNR>38_method[2]..43[30]..46[7]..17[15]..db_ui#notifications#error[1]..<SNR>42_notification[17]..<SNR>42_notification
_nvim_notify:
line 17:
Error connecting to db DEV DB exec error: Sqlcmd: The -E and the -U/-P options are mutually exclusive.
This happens regardless if I'm adding a connection manually or adding it to my config.
I'm using dadbod-ui, but if I just try the command I get the same output: The -E and the -U/-P options are mutually exclusive.
It seems to pass the -U/-P flags even though my connection string doesn't have a username and password and per the documentation it should add the integratedSecurity if I omit the username/pwd.
Supported query parameters are `authentication`, `secure` and
`trustServerCertificate`, which correspond to connection properties of the
same name. The `authentication` property is only supported when using
`go-sqlcmd`.
Is there something I'm doing incorrectly?
SQLCMD.EXE 16.0.1000… C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\SQLCMD.EXE