On Wed, Sep 7, 2016 at 9:24 PM, Josef Fortier <josef.fort...@gmail.com>
wrote:
> I'm attempting to use DBI with SQLite and am seeing an error:
> ...
> I've tested with a simple perl connection with the same connection string
> (driver=SQLite:dbname=db.sq3) which works.
>
> Looking at the help, I see examples for mysql, oracle etc, but not for
> SQLite.
>
>
True enough, I just added the following for dbext 24.00
let g:dbext_default_profile_POPFile =
'type=SQLITE:SQLITE_bin=C:\Programs\POPFile\sqlite.exe:dbname=C:\Programs\POPFile\popfile.db'
let g:dbext_default_profile_SQLite =
'type=SQLITE:SQLITE_bin=C:\download\OpenSrc\Databases\SQLite\sqlite3.exe:dbname=\vim\test\dbext\sqlite\test.db'
let g:dbext_default_profile_SQLite_DBI =
'type=DBI:driver=SQLite:conn_parms=dbname=\vim\test\dbext\sqlite\test.db'
let g:dbext_default_profile_SQLite_diff_cmdT =
'type=SQLITE:dbname=C:\vim\test\dbext\sqlite\test.db:cmd_terminator=~'
> Has SQLite through the DBI driver been tested?
No, I didn't realize they have a driver.
I just installed it and came up with this which works perfectly.
Here is a normal SQLite standard connection.
let g:dbext_default_profile_SQLite =
'type=SQLITE:SQLITE_bin=C:\download\OpenSrc\Databases\SQLite\sqlite3.exe:dbname=\vim\test\dbext\sqlite\test.db'
Here is the equivalent using DBI:
let g:dbext_default_profile_SQLite_DBI =
'type=DBI:driver=SQLite:conn_parms=dbname=\vim\test\dbext\sqlite\test.db'
HTH,
David
--
--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php
---
You received this message because you are subscribed to the Google Groups
"vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to vim_use+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
