[sqlalchemy] Re: Can't connect to SQLite databases

2017-06-20 Thread python howto
On Saturday, October 22, 2011 at 7:03:59 AM UTC-4, João Silva wrote: > > Hello everyone, > > I'm having a problem connecting to SQLite database files with > SQLAlchemy. :memory: databases work just fine, but whenever I'm trying > to access a file, the following happens: > > > Python 2.7.2 (defa

[sqlalchemy] Re: Can't connect to SQLite databases

2011-10-23 Thread jmsilva
On Oct 22, 9:00 pm, Michael Bayer wrote: > what happens if you say: > > import sqlite3 > import os > sqlite3.connect(os.path.abspath("test.db")) > > ? > > thats essentially what SQLA 0.7 does in order to guard against os.chdir() > changes as subsequent connections occur. > OK, you nailed it. The

Re: [sqlalchemy] Re: Can't connect to SQLite databases

2011-10-22 Thread Michael Bayer
what happens if you say: import sqlite3 import os sqlite3.connect(os.path.abspath("test.db")) ? thats essentially what SQLA 0.7 does in order to guard against os.chdir() changes as subsequent connections occur. On Oct 22, 2011, at 11:28 AM, jmsilva wrote: > On Oct 22, 2:18 pm, Michael Ba

[sqlalchemy] Re: Can't connect to SQLite databases

2011-10-22 Thread jmsilva
On Oct 22, 2:18 pm, Michael Bayer wrote: > strange.  what happens if you examine the "test.db" file more closely, is it > created with odd permissions (like not readable or something strange ?)   is > there a filesystem problem, can you reproduce this issue on any workstation > /environment ?