Issue 191: connecting to sql or sql ce
Status:  NoFix
Owner: ----
Closed:  Jul 2011
Reported by haris...@googlemail.com, Jul 26, 2011
I have a database in both sql and sqlce

when using sqlite on the windows cmd i do C:/Python>sqlite3 data.db < database.sql

Then I connect to the database as standard

Can i connect to the same .db file using pyodbc or do i have to do something different

in pysqlite it worked perfectly but i have to use sqlce (as per stakeholder requirements)

What version of the product are you using? On what operating system?

python 2.4 on windows 7 x64 bit

Please provide any additional information below.


Jul 28, 2011
Project Member #1 mkleehammer
You can use the ODBC driver here: http://www.ch-werner.de/sqliteodbc

Unfortunately you'll need some fixes that are checked in after 2.1.8 was released.  I'll try to make a build soon.

Status: NoFix