If I set

PRAGMA temp_store = MEMORY;

and

PRAGMA temp_store_directory = 'C:\scratch';

but TMP is set to an invalid directory, I get the following error

sqlite3.OperationalError: unable to open database file

Two suggestions:

1) If temp_store_directory is set, sqlite should not care what TMP is set to.

2) The sqlite3.OperationalError message should tell you the path to the file it 
is unable to open.

Thank you,
Roger


      
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to