dll load failed?..pls help

[zhayle]

i'm new to python programming..and i'm studying into one of its tutorials..I used pygres for its interface to the postgresql database..the problem is when i tried to run "import _pg" it has an error like this:

Traceback (most recent call last):
File "<pyshell#0>", line 1, in -toplevel-
import pg
File "C:\Python24\Lib\site-packages\pg.py", line 21, in -toplevel-
from _pg import *
ImportError: DLL load failed: The specified module could not be found.

ive checked the installation directory and i dont see any problem there..i couldnt figure out what is really the problem here..pls help..

[leegrube]

I am in the same spot you were in. Did you ever get an answer or figure it out?

Thanks in advance.

i'm new to python programming..and i'm studying into one of its tutorials..I used pygres for its interface to the postgresql database..the problem is when i tried to run "import _pg" it has an error like this:

Traceback (most recent call last):
File "<pyshell#0>", line 1, in -toplevel-
import pg
File "C:\Python24\Lib\site-packages\pg.py", line 21, in -toplevel-
from _pg import *
ImportError: DLL load failed: The specified module could not be found.

ive checked the installation directory and i dont see any problem there..i couldnt figure out what is really the problem here..pls help..

[kennethEntera]

actually im using pygresql also before going to the dll, copy the dll found in the postgresql library ahm it is found in the program files in c then postgresql/8.1/lib dn copy all the dll there then paste to the python directory where the pg module is found

[leegrube]

Thanks for the help Kenneth. I copied all the DLLs in the PostgreSQL\8.2\lib (there wasn't an '_pg.dll') folder to Python\Lib\site-packages (the only 'pg.*' files were pg.pyc & pg.pyo).

I tried to run my code again and got the same message

I'm an old school coder and DBA, but completely new OO and Python, so pardon me if I am being dense...

Also, I opened pg.pyc and saw a note which said it included the _pg module, so I added an 'import pg' stmt into my code. I ran and had the same error with that module.

This is a little frustrating.

[kennethEntera]

try using python 2.5 and the pygresql appropriate for python 2.5. this works for me.

[kennethEntera]

i think _pg.dll is already in the nstaller of pygresql. i have _pg.dll found in my python25/lib/site_packages directory