DBext (Vim) - A Valid Database type must be chosen

Question

Installed gvim on Windows and trying to run (Microsoft)sql server queries. Getting errors when I try to issue commands specific to dbext. Please see below for details.

Vimrc contains this connection string

:let g:dbext_default_profile_mySQLServer  = 'type=SQLSRV:integratedlogin=1:host=XXXXX:dbname=XXXXX'

SQL Statement

Select * from XXXXX

command:

<leader>se (in my case ,se)

Error: "A Valid database type must be chosen"

Can someone help me fix this problem in gvim + dbext set up.

Please note my plugin is installed properly and I see the plugin menu that list dbext commands.

Saccharose

did you figure out how to fix this? I am haveing the same problem – Destroyer

Answer 1

I'm a dbext newb myself with the exact same setup. That error message appears to be thrown whenever it can't identify the profile. From what I've read it should prompt you to select a specific named profile on execution but this doesn't seem to work for me.

However, getting dbext to recognize which named profile to load by default by adding the following line to the _vimrc under the named profile definition did get it working:

:let g:dbext_default_profile_mySQLServer = 'type=SQLSRV:integratedlogin=1:host=XXXXX:dbname=XXXXX'
:let g:dbext_default_profile = 'mySQLServer'

Ravel

Answer 2

You can use:

<leader>sbp or :DBPromptForBufferParameters

In order to display the profiles you've previously saved in your .vimrc

Dor