I have never used the pgdb module before, though I used the 'pg' module a couple years ago and was generally pretty pleased with what I could do with it.
I am now trying to get a Windows XP box configured to do DB work again. I got PostgreSQL installed without much problem, and the PygreSQL installer seemed to run fine. But Python is not happy when you say "import pgdb". First, it complained that it couldn't find libpq.dll. I found that under the PostgreSQL installation and simply copied the DLL into the C:\Python25\Lib\site-packages directory. That seemed to resolve that issue, but I immediately got another dialog making a similar complaint about ssleay32.dll. I didn't seem to have that anywhere on my system, so I located a copy via Google and also put that into the same directory and tried again. Now, it chokes, saying: "The application or DLL C:\Python25\Lib\site-packages\SSLEAY32.dll is not a valid Windows image. Please check this against your installation diskette." Man, I love Windows. (NOT!) There is no "installation diskette" of course, and putting the ssleay DLL into C:\Windows\system32 doesn't help either. So, the instructions for making a binary installation state: 2 Installing from a Binary Distribution This is the easiest way to install PyGreSQL. You can currently download PyGreSQL as Linux RPM, NetBSD package and Windows installer. Make sure the required Python version of the binary package matches the Python version you have installed. Install the package as usual on your system. Note that the documentation is currently only included in the source package. Well, there's a few pieces missing. It would be nice if the installer were aware of these prerequisites and could simply install the needed parts itself, but barring that, clear instructions about prerequisites prior to running the Windows installer or a troubleshooting guide that tells how to deal with common error messages would be really helpful. (i.e., I'm sure there must be at least a few others (or will be) that find themselves in the same situation - help them help themselves and avoid traffic here.) So, in the meantime, can anyone help me directly? i.e., Why does my system not like the ssleay32.dll that I have? Where can I get a copy my system accepts that causes "import pgdb" or "import pg" to return silently? Where should such DLL's rightly live? (FYI, my system is Windows XP (Home), my Python version is: Python 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)] on win32 and the version of PyGreSQL I got was indeed the 2.5 version: ftp://ftp.pygresql.org/pub/distrib/PyGreSQL-3.8.1.win32-py2.5.exe) Thanks! -ej _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
