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