connecting to sql or sql ce

[GoogleCodeExporter]

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.

Original issue reported on code.google.com by haris...@googlemail.com on 26 Jul 2011 at 2:12

[GoogleCodeExporter]

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.

Original comment by mkleehammer on 29 Jul 2011 at 1:10

• Changed state: NoFix
• Added labels: ****
• Removed labels: ****