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>
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. 5 5178
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 ===
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
Stef Mientki wrote:
I don't know if this matters, but I also use sqlite3 from other than
Python programs.
You have an instance of sqlite3.dll in P:\Python\DLLs for use with
Python, and (I guess) you have another instance of sqlite3.dll somewhere
else, for use "from other than Python programs". Are they the same
version? If not, this may be the problem. Start up your other
application, then try to import sqlite3 from Python. If this is the
problem, and you must be able to run both apps simultaneously, you will
probably need to update one or the other.
Cheers,
John
John Machin wrote:
Stef Mientki wrote:
>I don't know if this matters, but I also use sqlite3 from other than Python programs.
You have an instance of sqlite3.dll in P:\Python\DLLs for use with
Python, and (I guess) you have another instance of sqlite3.dll
somewhere else, for use "from other than Python programs". Are they
the same version? If not, this may be the problem. Start up your other
application, then try to import sqlite3 from Python. If this is the
problem, and you must be able to run both apps simultaneously, you
will probably need to update one or the other.
Cheers,
John
-- http://mail.python.org/mailman/listinfo/python-list
thanks John,
I think I hit the problem, ;-)
but I don't have a solution yet :-(
After creating the simplest program that did work :
import sqlite3
I started adding every import statement used in my program,
until the program crashed,
and here is the simplest program that crashes:
from scipy import *
import sqlite3
Traceback (most recent call last):
File "D:\Data_Python\P24_PyLab_Works\module1.py", line 2, in <module>
import sqlite3
File "P:\Python\lib\sqlite3\__init__.py", line 24, in <module>
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.
Any solutions ?
(btw I need to do the *-import, because I create an easy user
environment to do math and physics)
thanks,
Stef Mientki
hello,
through the scipy group I found a solution (no explanation yet),
import sqlite3
from scipy import *
solves the problem.
cheers,
Stef
Stef Mientki wrote:
John Machin wrote:
>Stef Mientki wrote:
>>I don't know if this matters, but I also use sqlite3 from other than Python programs.
You have an instance of sqlite3.dll in P:\Python\DLLs for use with Python, and (I guess) you have another instance of sqlite3.dll somewhere else, for use "from other than Python programs". Are they the same version? If not, this may be the problem. Start up your other application, then try to import sqlite3 from Python. If this is the problem, and you must be able to run both apps simultaneously, you will probably need to update one or the other.
Cheers, John -- http://mail.python.org/mailman/listinfo/python-list
thanks John,
I think I hit the problem, ;-)
but I don't have a solution yet :-(
After creating the simplest program that did work :
import sqlite3
I started adding every import statement used in my program,
until the program crashed,
and here is the simplest program that crashes:
from scipy import *
import sqlite3
Traceback (most recent call last):
File "D:\Data_Python\P24_PyLab_Works\module1.py", line 2, in <module>
import sqlite3
File "P:\Python\lib\sqlite3\__init__.py", line 24, in <module>
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.
Any solutions ?
(btw I need to do the *-import, because I create an easy user
environment to do math and physics)
thanks,
Stef Mientki
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: achan |
last post by:
I recently bought a new PC runnning in XP. I downloaded and installed
PySqlite 0.4.3win32 for Python 2.3. My Python23/Lib/Site-Packages/SQlite/
now has files __init__.py and main.py.
However,...
|
by: Laszlo Zsolt Nagy |
last post by:
Hello all,
Can anyone explain this:
C:\Python\Projects\DbDesigner>python
Python 2.3.4 (#53, May 25 2004, 21:17:02) on win32
Type "help", "copyright", "credits" or "license" for more...
|
by: Laszlo Zsolt Nagy |
last post by:
> exarkun@boson:~$ cat foo.py
> x = 10
> __all__ =
> exarkun@boson:~$ cat bar.py
> x = 20
> __all__ =
> exarkun@boson:~$ python -c "from foo import *; print x"
> ...
|
by: comp.lang.php |
last post by:
<?
header('Pragma: no-cache'); // ENSURE CLIENT-SIDE CACHE FLUSHING
$url = "$projectURLPath/index.php";
if ($_REQUEST) $url .= '?logoutMsg='.
urlencode($_REQUEST);
if ($willAuthenticate &&...
|
by: mrjaxon |
last post by:
Basically the issue is, when the XSL style sheet is loaded by URI it
is cool but when the exact same style sheet loaded by it's contents
the load fails (for this particular style sheet). Because...
|
by: defn noob |
last post by:
i unzipped and put the folder in site-packages. when i run setup.py
install nothing happens.
when i do import pp from shell it complains it doesnt exist.
isnt placing the folder in...
|
by: Stef Mientki |
last post by:
hello,
I'm running Python 2.5 and want my programs to run at least under
Windows and Linux (preferable also Mac).
So I guess I should always use relative paths.
From most modules I can call a...
|
by: Gabriel Genellina |
last post by:
En Sat, 18 Oct 2008 05:52:04 -0300, Stef Mientki <stef.mientki@gmail.com>
escribió:
Why don't you let the caller tell you its own location, using __file__?
The above code is too much magic for...
|
by: tvnaidu |
last post by:
database file gets created using below sql file, then lua script calls "db.import config_ascc", then I get errors says "insert table failed for eventLog", below are my sql file entry, config file,...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
| |