John Machin wrote:
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?
P is just a normal local drive,
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?
Indeed, the only thing I've changed is the pathname.
I also installed
* install python 2.5.2 msi
* install numpy 1.0.4
* install scipy 0.6.0
* install wxPython + docs-demo 2.8.7.1 unicode
* install MatPlotLib 0.91.2
* install Pygame + docs 1.8.0
* install SendKeys 0.3
* install PyScripter 1.7.2 , updated to 1.9.9.1 !!!
* install Rpyc 3.0
* install ConfigObj 4.5.2 , unpack in sitelibs and run "python
setup.py install"
I don't know if this matters, but I also use sqlite3 from other than
Python programs.
What version of Python are you using? What version of Windows?
Windows-XP - sp2
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 ===
==== looks identical to me ====
C:\Documents and Settings\Administrator>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__
'P:\\Python\\DLLs\\_sqlite3.pyd'
==== end =====
Any other suggestions ?
thanks,
Stef
--
http://mail.python.org/mailman/listinfo/python-list
--
http://mail.python.org/mailman/listinfo/python-list
