Re: connect to a remote Postgresql server using DBI

From: Gokul P. Nair (gpnair78_at_yahoo.com)
Date: 03/04/05 

Date: Fri, 4 Mar 2005 09:48:36 -0800 (PST)
To: dbi-users@perl.org

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 remote database. Do i
have to download and install the database driver as
well as client libraries for each computer running the
perl script to execute queries on the remote server?
What if i were to run these perl scripts on a windows
machine, would downloading and installing the driver
alone not suffice?

Thanks again.
Gokul
 
--- Alec Brecher <alec@eresearchresources.com> wrote:

> 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, 3 Mar 2005 21:08:27 -0800 (PST), Gokul P.
> Nair wrote:
> > i would like to connect to a remote postgresql 8.1
> server using a
> > perl script. The machine i'm trying to connect
> from is running
> > Debian and perl v5.6.1. In order to connect to the
> remote
> > postgresql server i assume i need DBI as well as
> DBD::Pg. well the
> > DBI installation went well but when i try to
> install DBD::Pg this
> > is what it gives me:
> >
> > debian:/usr/local/src/DBD-Pg-1.40# perl
> Makefile.PL Configuring Pg
> > Remember to actually read the README file! Path to
> pg_config? OS:
> > linux PostgreSQL version: ..
> >
> > ****************
> > WARNING! DBD::Pg no longer supports versions less
> than 7.2.
> > It is highly recommended that you upgrade
> PostgreSQL to a newer
> > version. ****************
> >
> > Using DBI 1.47 (for perl 5.006001 on i386-linux)
> installed in
> > /usr/local/lib/perl/5.6.1/auto/DBI/ Checking if
> your kit is
> > complete... Looks good
> > Note (probably harmless): No library found for
> -lpq Using DBI 1.47
> > (for perl 5.006001 on i386-linux) installed in
> > /usr/local/lib/perl/5.6.1/auto/DBI/ Writing
> Makefile for DBD::Pg
> >
> > Do i even need DBD::Pg installed on the machine
> which is trying to
> > access the postgresql server through a perl
> script? if so why is
> > the very first step i.e. "perl Makefile.pl"
> failing? if no, how do
> > i connect to the server and run queries using
> perl?
> >
> > thanks in advance for all ur help.
> >
> > Gokul
> >
> >
> > __________________________________________________
> Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
>
>
>

        
                
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/

Relevant Pages

  • Re: Cant call method "prepare" on an undefined value
    ... Somehow you managed to have an undefined value instead of a DBI database handle in front of ->prepare, which is burried deep inside Oraperl.pm. ... Oracle HTTP Server at Server B. Both server are Solaris server. ... I have installed DBI and DBD into Server B and setup the oraperl in my perl script. ...
    (perl.dbi.users)
  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... the installation hangs at "Validating User. ... > Database 'msdb' cannot be opened. ... > See the SQL Server errorlog for more information. ...
    (microsoft.public.sqlserver.setup)
  • Re: The Web site that is referenced here is not in the configurati
    ... there's a link to the ISA Server. ... The question is what is happening with the Config Database that leads to the ... disappearance of the top-level web site form the configuration. ... A client of ours has an installation of SBS2003 Premium. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Cannot save document. Form Validation Error..Web Server is busy
    ... It is observed that in Sharepoint Portal Server 2003, ... database is installed on a MSDE instance. ... Is there a way to convert/migrate/ that database instance to SQL ... assuming the installation directory of SQL server is on C ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SQLExpress New DB
    ... SQLEXpress onto my PC which is running VISTA Home Premium. ... think I am trying to configure a full installation of SQL server? ... Is the database being created on the same ...
    (microsoft.public.sqlserver.connect)