Re: connect to a remote Postgresql server using DBI

2005-03-04 Thread Alec Brecher
You need to install the PostgreSQL client libraries on the box running DBD::Pg. The client libraries need to be installed before installing DBD::Pg. See the bottom of this page for client installation directions. http://www.postgresql.org/docs/7.4/static/install-procedure.html -Alec On Thu,

Re: connect to a remote Postgresql server using DBI

2005-03-04 Thread Gokul P. Nair
Thanks very much for ur response, i have one more question though. Isn't there some kind of arrangement like MS ODBC where u just download the driver for the specific database and then create a DSN (data source name) and write ur scripts (perl script or anything else) to execute queries on the

Re: connect to a remote Postgresql server using DBI

2005-03-04 Thread Alec Brecher
You need all the layers compiled on windows or *nix to make it work: DBI DBD::Pg PostgreSQL client library. If you are installing on Windows be sure to read the windows readme when installing the PostgreSQL client. It is a bit tricky. -Alec On Fri, 4 Mar 2005 09:48:36 -0800 (PST), Gokul P.

Re: connect to a remote Postgresql server using DBI

2005-03-04 Thread Hardy Merrill
Typically for every client machine, you would do as Alec suggested - first install the client libraries for the specific database being used, and then install the DBD:: for that specific database. There is an alternative, and that is to use DBI::ProxyServer and DBD::Proxy. It's been several