#73 Cannot use Psycopg

[Anonymous]

Originally created by: jdmargul...@gmail.com

What steps will reproduce the problem?
1. Download http://www.stickpeople.com/projects/python/win-psycopg/2.5.1/psycopg2-2.5.1.win-amd64-py2.7-pg9.2.4-release.exe
2. Attempt installation from the winpython control panel

This generates a pop-up message declaring the module to be incompatible with winpython.

I have also tried this link: http://www.lfd.uci.edu/~gohlke/pythonlibs/#psycopg

It installs fine but the package import fails because of a .pyd module:

ImportError: DLL load failed: The specified module could not be found.

This in spite of the .pyd module being in the package directory as it should.

Is the issue with .pyd files?

I'm using winpython 2.7.5.1 on a Windows 7 64-bit machine.

Thanks!!

[Anonymous]

Originally posted by: jdmargul...@gmail.com

Thank you very much for the answer. Can you clarify "libpq.dll in the PATH"? How would that overcome the fact that Python fails to import the _psycopg.pyd module?

[Anonymous]

Originally posted by: jdmargul...@gmail.com

OK, thanks. Which "PATH" do I add libpq.dll to?

[Anonymous]

Originally posted by: jdmargul...@gmail.com

I've added the .dll to psycopg2's directory knowing nothing better and here is the error I now get:

    from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: DLL load failed: %1 is not a valid Win32 application.

Any clue?