From: arthur8@... (Arthur)
Date: 2003-05-13T19:51:16+09:00
Subject: ruby dbi obdc driver to remote postgresl (broken)?

I'm not sure if this is a known bug.  I haven't been able to get it to
work, and have not found any further references to it.

My situation:  I am running a ruby application on Windows 2000, trying
to connect to a remote PostgreSQL database running on a Linux box.  I
installed Andy Hunt's ruby package for Windows which includes ODBC and
Postgres drivers.  I first tried using ruby dbi to connect to the
PostgreSQL database using the installed PostgreSQL DBD.  No luck.

I then installed an additional tool that includes an ODBC driver for
Postgres, allowing me to view the PostgresQL database tables.  This
indicates that the ODBC driver for Postgres works.  I changed the
DBI.connect string in my ruby script to use the ODBC prefix rather
than Pg.  Still no luck.

After a few experiments, I found that I am able to connect to remote
local and remote SQLServer databases using that same DBI ODBC driver. 
As far as I can tell, the ODBC driver works fine, but the DBI
interface to the ODBC driver and the DBI interface to the Postgres
driver both fail.

Has anyone encountered this?  


Thanks,

Arthur