MS SQL Server adapter -U/-P flags passed in SQL Server connection string
```lua
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`
4 条评论