Error on one Machine: "ImportError: DLL load failed: %1 is not a valid Win32 application.", Seems to be SQLite related

[Ben Smith]

Hey Folks -

I've got one app that my subgroup uses to do data analysis. It is working
on all but one machine. On the non-working machine they get:
Traceback (most recent call last):

File "Y:\Software\RunRawData\App\RunRawData.py", line 2, in <module>

import sqlite3

File "C:\Python27\lib\sqlite3\__init__.py", line 24, in <module>

from dbapi2 import *

File "C:\Python27\lib\sqlite3\dbapi2.py", line 27, in <module>

from _sqlite3 import *

ImportError: DLL load failed: %1 is not a valid Win32 application.

<<

What throws me is that this user has used scripts with SQLite before, so I
have a hard time understanding why it would be a problem.

Any ideas?

[Matthew Zaleski]

Post by Ben Smith
Hey Folks -
I've got one app that my subgroup uses to do data analysis. It is working
File "Y:\Software\RunRawData\App\RunRawData.py", line 2, in <module>
import sqlite3
File "C:\Python27\lib\sqlite3\__init__.py", line 24, in <module>
from dbapi2 import *
File "C:\Python27\lib\sqlite3\dbapi2.py", line 27, in <module>
from _sqlite3 import *
ImportError: DLL load failed: %1 is not a valid Win32 application.
<<
What throws me is that this user has used scripts with SQLite before, so I
have a hard time understanding why it would be a problem.
Any ideas?

I can't resist: http://bit.ly/Jst751

Several hits before matching your post on gmane :)

[Ben Smith]

Cute. But those posts actually don't pertain to what I'm asking. Thus the
reason I posted the question (I did google it first)

Post by Matthew Zaleski

Post by Ben Smith
Hey Folks -
I've got one app that my subgroup uses to do data analysis. It is
File "Y:\Software\RunRawData\App\RunRawData.py", line 2, in <module>
import sqlite3
File "C:\Python27\lib\sqlite3\__init__.py", line 24, in <module>
from dbapi2 import *
File "C:\Python27\lib\sqlite3\dbapi2.py", line 27, in <module>
from _sqlite3 import *
ImportError: DLL load failed: %1 is not a valid Win32 application.
<<
What throws me is that this user has used scripts with SQLite before, so
I have a hard time understanding why it would be a problem.
Any ideas?

I can't resist: http://bit.ly/Jst751
Several hits before matching your post on gmane :)

[Matthew Zaleski]

I do believe they are relevant. The failure has been demonstrated to be
caused by DLL hell problems. You are 100% absolutely, positively sure that
no one has installed anything since the sqlite3 stuff worked the last time?
Then likely the hard drive corrupted.

Post by Ben Smith
Cute. But those posts actually don't pertain to what I'm asking. Thus the
reason I posted the question (I did google it first)

Post by Matthew Zaleski

Post by Ben Smith
Hey Folks -
I've got one app that my subgroup uses to do data analysis. It is
File "Y:\Software\RunRawData\App\**RunRawData.py", line 2, in <module>
import sqlite3
File "C:\Python27\lib\sqlite3\__**init__.py", line 24, in <module>
from dbapi2 import *
File "C:\Python27\lib\sqlite3\**dbapi2.py", line 27, in <module>
from _sqlite3 import *
ImportError: DLL load failed: %1 is not a valid Win32 application.
<<
What throws me is that this user has used scripts with SQLite before, so
I have a hard time understanding why it would be a problem.
Any ideas?

I can't resist: http://bit.ly/Jst751
Several hits before matching your post on gmane :)