Error loading PYD file procedures in PyODBC

[Jay Osako]

NOTE: This has also been posted to the Python forum on Daniweb (http://
www.daniweb.com/software-development/python/threads/367218). I
wouldn't normally cross-post a message like this, but I did not know
at the time about this list, otherwise I would have posted here to
begin with.

I am trying to set up Django and PyODBC, and while I've had some
success, a problem has arisen. At this time, running 'manage.py
syncdb' in the relevant directory results in the following traceback:

Traceback (most recent call last):
File "C:\Python26\Lib\site-packages\AllProBugProWeb\proj\manage.py",
line 11,
in <module>
import settings
File "C:\Python26\Lib\site-packages\AllProBugProWeb\proj
\settings.py", line 3,
in <module>
import pyodbc
File "build\bdist.win32\egg\pyodbc.py", line 7, in <module>
File "build\bdist.win32\egg\pyodbc.py", line 6, in __bootstrap__
ImportError: DLL load failed: The specified procedure could not be
found.


When trying to access the website, a different ImportError is raised,
one which I suspect is a different problem (perhaps a misconfiguration
of some sort on my part) but may still be relevant in tracking down
the first issue:

Internal Server Error
An error occurred processing this request.

--------------------------------------------------------------------------------

Request handler failed

Traceback (most recent call last):
File "C:\Python26\Lib\site-packages\AllProBugProWeb\Http\Isapi.py",
line 67, in Request
return RunWSGI(Handler, Base=Base)
File "C:\Python26\Lib\site-packages\AllProBugProWeb\Http\WSGI.py",
line 155, in RunWSGI
Result = Application(Environ, StartResponse)
File "c:\Python26\Lib\site-packages\django\core\handlers\wsgi.py",
line 250, in __call__
self.load_middleware()
File "c:\Python26\Lib\site-packages\django\core\handlers\base.py",
line 39, in load_middleware
for middleware_path in settings.MIDDLEWARE_CLASSES:
File "c:\Python26\Lib\site-packages\django\utils\functional.py",
line 276, in __getattr__
self._setup()
File "c:\Python26\Lib\site-packages\django\conf\__init__.py", line
42, in _setup
self._wrapped = Settings(settings_module)
File "c:\Python26\Lib\site-packages\django\conf\__init__.py", line
89, in __init__
raise ImportError("Could not import settings '%s' (Is it on
sys.path?): %s" % (self.SETTINGS_MODULE, e))
ImportError: Could not import settings 'proj.settings' (Is it on
sys.path?): DLL load failed: The specified procedure could not be
found.



Additional Information

--------------------------------------------------------------------------------


-- Module Search Path --

C:\Python26\Lib\site-packages\AllProBugProWeb
c:\Python26\Lib\site-packages\pyodbc-2.1.8-py2.6-win32.egg
C:\Python26\lib\site-packages\django_mssql-1.0.0.dev_unknown-py2.6.egg
C:\Python26\lib\site-packages\pymssql-1.9.909_dev-py2.6-win32.egg
C:\Python26\lib\site-packages\ipython-0.10.2-py2.6.egg
C:\Python26\lib\site-packages\nose-1.0.0-py2.6.egg
c:\Python26
c:\Python26\bin
c:\Python26\Lib\site-packages
c:\django-pyodbc
c:\pywin32
C:\Python26\Lib\site-packages\pywin32_system32
c:\pywin32\win32
c:\pywin32\win32\lib
c:\pywin32\Pythonwin
C:\Windows\system32\python26.zip
C:\Python26\Lib
C:\Python26\DLLs
C:\Python26\Lib\lib-tk
c:\windows\system32\inetsrv
C:\Python26\lib\site-packages\win32
C:\Python26\lib\site-packages\win32\lib
C:\Python26\lib\site-packages\Pythonwin
c:\Python26\bin
c:\Python26\Lib\site-packages\AllProBugProWeb


-- Other Path Info --

Current Directory = 'C:\Python26\Lib\site-packages\AllProBugProWeb'
Python Home = '<Auto>'
sys.executable = 'C:\Python26\Lib\site-packages\AllProBugProWeb
\PyISAPIe.dll'
sys.exec_prefix = 'C:\Python26'
sys.prefix = 'C:\Python26'

I included the path data following the traceback because it may be
relevant in tracking the problem down. The dev system is a Win7 32-bit
virtual machine running in VirtualBox; the underlying parent systems
vary (hence the use of the relatively consistent and easily duplicated
VM image). The target database is MS SQL Server Express 2008 R2, and
the PyODBC and Django-PyODBC libraries were compiled from sources with
MinGW32 (gcc 4.4.1as the compiler). The Python interpreter is the
standard CPython 2.6 downloaded directly from python.org and installed
automatically.

[Michael Kleehammer]

Two things: (1) I wouldn't recommend MinGW over the precompiled binaries if you can use them and (2) do any of the other libraries packaged as eggs work?  Can you try copying the .pyd, not egg, into C:\Python26\Lib\site-packages?