SQLite import fails sometimes ?

[John Machin]

Stef Mientki wrote:
> hello,
> 
> The import statement "import sqlite3" gives the error given below.
> In simple programs, the import statement (sometimes) succeed,
> and I can indeed access the database.
> So I guess there is some conflict with another part of my program,
> but as the program is rather large (and dynamic) it's not easy to 
> isolate the problem.
> Does anyone has a clue how to trace this kind of problem ?
> 
> thanks,
> Stef
> 
> Traceback (most recent call last):
>  File "bricks\brick.py", line 322, in Exec
>    self.Generate_Output_Signals ()
>  File "bricks\brick_dBase.py", line 61, in Generate_Output_Signals
>    import sqlite3
>  File "P:\Python\lib\sqlite3\__init__.py", line 24, in <module>

Is P: a network drive? If not, what is it?
I presume from the fact that the next part of the path is not 
\Python25\Lib that you have not performed a default installation; other 
than the changes to the path name, what else have you done?
What version of Python are you using? What version of Windows?

>    from dbapi2 import *
>  File "P:\Python\lib\sqlite3\dbapi2.py", line 27, in <module>
>    from _sqlite3 import *
> ImportError: DLL load failed: Invalid access to memory location.

Looks like the problem could be with your copy of _sqlite3.pyd (pyd == 
Python DLL)

Try why I did below and tell us how far you got.
Cheers,
John

=== try this ===
C:\junk>python
Python 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit 
(Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
 >>> from _sqlite3 import *
 >>> import _sqlite3
 >>> _sqlite3.__file__
'c:\\python25\\DLLs\\_sqlite3.pyd'
=== end ===