Author: Ed Leafe
Posted: 2006-11-19 at 17:30:33
On Nov 19, 2006, at 2:30 PM, HWP wrote:
> I have created a sqlite3 db in python2.5. Can I access it using the
> appwizard in
> dabo 0.7? So far no luck. I can create a connection in the
> connection editor and
> it tests ok. But in the app wizard this same connection generates
> an error:
>
> File "d:\program
> files\python24\lib\site-packages\Dabo-0.7s-py2.4.egg\dabo\db
> \dbSQLite.py", line
> 74, in getTables
> tempCursor.execute("select * from sqlite_master")
> OperationalError: unsupported file format
>
> Any ideas?
I've gotten that error when trying to access a sqlite database
created in another version than the one on the machine being used.
For example, I had a test sqlite database that I copied over to an
Ubuntu machine, and got that error. The connection editor just checks
to make sure that the connection parameters are valid; in the case of
a sqlite connection, as long as the database exists, it will report
success, since there is no login requirements.
I haven't played with the sqlite support in Python 2.5 yet, as I've
been trying to keep things standardized before our release. My guess
is that there may be some syntax differences, although I would be
surprised if they were significant.
-- Ed Leafe