New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sqlcmd hangs vim on windows7 #37

Open
dhazel opened this Issue Nov 1, 2018 · 1 comment

Comments

Projects
None yet
2 participants
@dhazel

dhazel commented Nov 1, 2018

Environment
Vim8 on Windows7

Issue
When calling DB to connect to an sqlserver database, a spawned command window stays open and vim hangs until the window is closed. (names below are redacted for security)

:DB g:sandbox = sqlserver://username:password@server

Notes
This behavior does not happen when using osql in place of sqlcmd. In that case, there is no spawned command window left hanging open, and dadbod works as expected.

Desired Outcome
I would like to be able to use sqlcmd rather than osql because sqlcmd has the -W option that will trim trailing whitespace from the query results. Without trimmed trailing whitespace, for the db's I am working with, the fields are returned absurdly long, making the output nearly unreadable.

What I've Tried

  • Skimming the dadbod code for clues about how input/output are handled. Unfortunately, my combined vimscript and windows command line skills are too weak given the time I have for debugging.
  • Swapping out sqlcmd for osql. The results of that are included in the write-up above.
@tpope

This comment has been minimized.

Owner

tpope commented Nov 1, 2018

This is out of my wheelhouse, but see #5 for some context.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment