[Tutor] Cannot open SQLite database
alan.gauld at btinternet.com
Wed Feb 24 10:09:27 CET 2010
"Timo" <timomlists at gmail.com> wrote
> OperationalError: unable to open database file
Does the file actually exist where you say it does?
> # This will return: C:\Documents and Settings\user\Application Data\myapp
> PREFDIR = os.path.join(os.environ['APPDATA'], 'myapp')
Do you check that APPDATA is actually set?
> # Connect to the database
> def db_connect():
> conn = sqlite3.connect(os.path.join(PREFDIR, 'myapp.db')) # This
Do you do an is file exists check before trrying to use it?
And that the permissions on both directory and file are set up correctly?
That would be my guess at likely errors.
Author of the Learn to Program web site
More information about the Tutor