[python-win32] Re: py2exe runtime problem...(SOLVED)

[Eric Walstad]

Hi Jim,

Jim Vickroy wrote:
> I have been using pysqlite for some time; I always install it using the Windows binary installer
> provided with the distribution.  It never installs a file called sqlite.dll anywhere on my system.
> At least when installed in this manner, Gerhard has said there is no need for a sqlite.dll (its
> built into the distribution).
Hmm, perhaps this is part of the problem then...

Yes.  I had installed sqlite in my site-packages directory.  That was my
mistake because, after following your install procedure below, pysqlite
installs itself in site-packages/sqlite.  I'm not clear on exactly where
the name conflict was happening, but it's gone now.  Yippee!

IMO, it seems a bit odd to stick pysqlite in a dir named sqlite.


> I just looked at the link you mentioned, and I guess you built the installation on your system so
> that is why you needed sqlite.dll.  I may be wrong but I think that once you build the pyd file,
> sqlite.dll is no longer needed in order to use pysqlite.  If I had a sqlite.dll on my system, I
> would (temporarily) rename it and see if anything broke, but I don't have one to play with.
Hehe.  That's exactly what I did after I read your first email.
Actually, I zipped up the whole sqlite installation folder, removed all
the copies of sqlite.dll and then tried it... and it failed on:
import sqlite
Which resulted with something like "No module sqlite"


>  Anyway
> ...
> 
> ... that's why I'm confused.
I was too!  Thanks for your brain cycles and for steering me in the
right direction!  ;^)

Eric.

PS, off list, please tell me where you keep your sqlite installation
(I'm guessing you still use the sqlite command line tool for admin stuff).