search

djhenderson / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

connecting to sql or sql ce #191

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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 commented 9 years ago 
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