[PyGreSQL] Problem with installation of PyGreSQL

[Christoph Zwerschke]

Hi Craig,

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

 > Any ideas of what the problem might be?

This looks like the PostgreSQL C interface (libpq.dll) is not installed 
or its directory (usually C:\Programs\PostgreSQL\8.1\bin) is not in your 
Windows PATH.

> I am also curious about "classic PyGreSQL" vs "DB-API 2.0 compliant".  I'm
> not necessarily concerned about being able to use the same API to connect to
> multiple different database systems.  Any recommendations?

Using DB-API has the advantage that you can can not only easily change 
the database, but also the database driver. The classic interface offers 
some interesting low-level and high-level methods that DB-API does not 
provide. Try experimenting with both to find out which you like more.

-- Christoph