search

tpope / vim-dadbod

dadbod.vim: Modern database interface for Vim
https://www.vim.org/scripts/script.php?script_id=5665
3.69k stars 131 forks source link

Problems to connect to a SQL SERVER on windows 10 #101

Closed gorrioncillo closed 2 years ago

gorrioncillo commented 2 years ago

I use vim8.2 and gitBash from git for windows portable instalation on windows 10 SO. I installed this plugin just cloning it as the readme show. When I run :DB sqlserver://SERVER_URL an as it is supposed it will use -E option Vim show me the following error: Sqlcmd: The -E and the -U/-P options are mutually exclusive.

The output of :echo db#adapter#sqlserver#interactive("sqlserver://SERVER_URL") is: ['sqlcmd', '-S', 'SERVER_URL', '-E'] SO I do not know what is going on here.

Any help will be great. Thanks in advance.

tpope commented 2 years ago

That's strange. Does it work if you call it without -E?

gorrioncillo commented 2 years ago

Sorry to say but my server only accept window autentication (-E option). But I tried :DB sqlserver://SERVER-URL;user just to avoid the -E and it seems to work, but i cannot comfirm that

tpope commented 2 years ago

Lacking information as to the root cause, I'm going to endorse your workaround as the solution.