Page 1 of 1

use SQLite in PrimalSQL

Posted: Tue Aug 16, 2011 4:30 am
by gabriel.guardiola@bnpparibas.com
Helloi want to use sqlite directly in PrimalSQL. I have started to install http://system.data.sqlite.org/index.htm ... loads.wiki it's sqlite dot.net client ADO db, still cannot see how to use it. Is there a way?thanks

use SQLite in PrimalSQL

Posted: Tue Aug 16, 2011 4:54 am
by davidc
You should be able to connect to SQLite using ODBC or OLE DB. Currently PrimalSQL 2011 doesn't interact directly with the sqlite dot.net client. David

use SQLite in PrimalSQL

Posted: Tue Aug 16, 2011 9:49 pm
by gabriel.guardiola@bnpparibas.com
Ok i finnaly found.odbc driver found http://www.ch-werner.de/sqliteodbc/for PrimalSQL need to use 32b driver on windows seven 64b

use SQLite in PrimalSQL

Posted: Wed Aug 17, 2011 4:00 am
by davidc
Yes, you will need the 32bit provider.David