search

microsoft / go-sqlcmd

The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)
https://learn.microsoft.com/sql/tools/sqlcmd/go-sqlcmd-utility
MIT License
323 stars 56 forks source link

What jdbc connection string property corresponds with the `-G` flag? #509

Closed michaelstack closed 4 months ago

michaelstack commented 4 months ago

I am trying to get vim-dadbod to work with sqlcmd -G.

It already works fine with sqlcmd without the -G flag, but now I need to access a database for which there is no connect string access, and the only way I can connect is using sqlcmd -G.

I have this issue open on the vim-dadbod repo: https://github.com/tpope/vim-dadbod/issues/152

To progress that issue, I want to find the jdbc connect string property that corresponds with sqlcmd's -G flag.

From the docs at https://learn.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver16 , it looks like the closest one is authentication=ActiveDirectoryIntegrated.

Can anyone comment on whether that property and the -G flag do the same thing, or similar things, or different things?

michaelstack commented 4 months ago

Having read a bit further I think I was asking the wrong question