dbext is a vim plugin containing functions/mappings/commands to enable Vim to access several databases.
dbext is a vim plugin containing functions/mappings/commands to enable Vim to access several databases.
Questions tagged [dbext]
14 questions
6
votes
2 answers
DBext (Vim) - A Valid Database type must be chosen
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 …
Pradeep Krishnaraj
- 99
- 5
3
votes
1 answer
Config Vim plugin dbext to read password from a file
I like Vim, enjoyed all the different plugins and dbext is one of them
However not happy with the fact that password is displayed as clear text on command line
Is there a way to configure dbext so it reads password from a file?
Ask and Learn
- 8,661
- 8
- 37
- 43
2
votes
0 answers
error running sqlcmd using vim dbext though equivalent command runs manually
I am trying to use vim+dbext to run queries on an AzureSQL db using sqlcmd. The Result window shows an error:
Connection: T(SQLSRV) S([SERVER]) D([DB]) U([USER]) at 17:05
job started:17:05:47 updates every 2000 ms
To change…
cudima
- 414
- 4
- 11
2
votes
1 answer
dbext does not recognize statement terminator with dbi / oracle settings
I trying to use gVim with dbext plugin.
The settings in my _vimrc are:
let g:dbext_default_profile_myoradb = 'type=DBI:driver=Oracle:user=ora1:passwd=ora1:conn_parms=myoradbr:driver_parms=AutoCommit=0;CommitOnDisconnect=0'
let…
0xdb
- 3,539
- 1
- 21
- 37
2
votes
1 answer
dbext seems to think ( is a sql statement terminator
I have this in the .sql file in my buffer:
CREATE TABLE WH.dbo.customer(
id INTEGER NOT NULL,
cust_name VARCHAR(30) NOT NULL,
phone_nbr VARCHAR(30) NULL,
PRIMARY KEY(id)
);
If I am in…
whytheq
- 34,466
- 65
- 172
- 267
1
vote
1 answer
How can I include the SID for a DBI Oracle connection?
I dont cant connect to Oracle database with dbi perl module.
If i use ORA type connection i can.
"ORA Profile connection:
let g:dbext_default_profile_myConnection= 'type=ORA:srvname=//myIP.IP.IP.IP\:myPORT/mySID:user=myUSER:passwd=myPASSWORD'
With…
Loopzen
- 11
- 1
1
vote
1 answer
Switching to next/prev connection in DBExt
In DBExt, you can change your connection with
DBSetOption profile=
But is there a way to switch between connections like next or previous? Or would I have to make a vimscript function to deal with that?
Olle Härstedt
- 3,799
- 1
- 24
- 57
1
vote
1 answer
vim: dbext output unreadable
I'm running: Windows 7, gvim 7.4
Put this in my vimrc:
"------------dbext--------------
" Microsoft SQL Server
let g:dbext_default_profile_microsoft_production = 'type=SQLSRV:integratedlogin=1:dsnname=SQLOLEDB.1:srvname=SVR:extra=-t'
Tried it with…
red888
- 27,709
- 55
- 204
- 392
0
votes
1 answer
Writing dbext query output in buffer to a CSV file
I currently I have Vim set up with the dbext plugin to run queries against a database. After running a query, it creates a new buffer for the output results.
So far, this setup works okay if I just want to see the output of a query, but instead I…
bobfet1
- 1,603
- 21
- 22
0
votes
1 answer
dbext Connection to SQL Server on OSX (/usr/local/bin/osql: illegal option -- w)
I've been trying to get dbext to connect to an external SQL server instance on OSX using MacVim.
So far I've tried a few iterations of different connection strings all of which return /usr/local/bin/osql: illegal option -- w.
This makes me think…
JWheeler
- 320
- 4
- 14
0
votes
1 answer
dbext freeze when running SQL
I am using neovim with dbext;
In my init.vim i have this line
let g:dbext_default_profile_local_PSQL = 'type=PGSQL'
I have test file: test.sql.
In file is:
select * from products;
when i run \sel
nvim shows:
dbext: Executing SQL at…
lukas kiss
- 381
- 2
- 15
0
votes
1 answer
dbext not finding sql snippets to execute
I'm trying to use the dbext vim plugin to connect to a MySQL database.
When I give commands like se I get an error:
Can't open file
/var/folders/b3/s3wyytf90_ld113h1w3p86ldcg4glv/T/vQ0XMX3/7
That file doesn't exist. But the SQL I expect to…
Lindsay Winkler
- 751
- 5
- 13
0
votes
0 answers
Vim jumplist is not updated by
Pressing does not update the jumplist (evidenced by :jump). Jumping to count , e.g. 10 opens the correct jump, however, this also does not update the jumplist nor moves the jump pointer to a new location.
The following…
user3156459
- 1,123
- 2
- 9
- 17
0
votes
2 answers
Can vim/dbext use integrated security rather than a sql-login to access db
Currently I can access our db using vim with the standard dbext plugin.
I'm using the details of one of our a sql-server-logins to achieve this:
type=SQLSVR:user=userName:psswd=userPwrd:dsnname=SQLOLEDB.1:srvname=boxname
Could I change this…
whytheq
- 34,466
- 65
- 172
- 267