Python 2.7 and SQLite on Windows 7: unable to open database file

[Bryce Cutt]

I am having an odd issue with Python 2.7 and SQLite and am wondering if anyone has seen it or has some insight.

I recently decided to try porting some of my Python apps to the python27 runtime and the first step was to install Python 2.7 on my dev machine (Windows 7 64bit). Now whenever I run an app with --use_sqlite I get the exception "InternalError: unable to open database file" as soon as I try to write an entity to the datastore. I have traced this back to sqlite being unable to write some temp files to my "C:\Windows" folder (see issue linked below).

I have tried to detail as much as possible in my response to this issue:

http://code.google.com/p/googleappengine/issues/detail?id=7717

I am a bit stumped on what to do next. For now I have gone back to developing with Python 2.6 but that is not really a solution.

- Bryce

[Robert Fischer]

I know this probably isn't what you're looking to hear but I had the same problem and was able to "solve" it by running the dev server as administrator.

Another benefit to this is being able to run on :80.

I'd love to hear about a better solution though...

-Robert Fischer

www.DealScorcher.com

- Bryce

--
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/2CCuwzuo5WYJ.
To post to this group, send email to google-a...@googlegroups.com.
To unsubscribe from this group, send email to google-appengi...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.

[Robert Fischer]

What I mean to say is I gave up on a proper "fix" so that I could work, but would love find out why it's not working when it's running as the same user who owns and also has permission to the database.

-Robert Fischer

www.DealScorcher.com

[Bryce Cutt]

Hi Robert,

I have been digging into it a bit more and I know what is happening, I just don't know why it is happening. I have a temporary solution that does not require running as administrator. I detailed all this on the issue page so it is all in one place.

- Bryce