Front page | perl.dbi.users |
Postings from August 2001
I failed on my first attempt in similar circumstances, though I did get an
error.
The solution in my case was as simple as lowercasing the "DBI" in the
connection string, i.e. like:
$dbh = DBI->connect("dbi:Pg:dbname=$TEST_REGISTRY");
Note also the single colon between "dbi" and "Pg".
I am too inexperienced in DBI to have any idea why that would make a
difference, so: try it and see if it works for you.
> -----Original Message-----
> From: anuradha [SMTP:anuradha@infy.com]
> Sent: Monday, August 13, 2001 1:58 AM
> To: dbi-users@perl.org
> Cc: Tim.Bunce@ig.co.uk
> Subject: DBI Connectivity problem
>
> Hi ,
>
> I have a problem in DB connectivity.
>
> I working with CGI,Perl language and Postgres Database.
> I installed the DBI-1.19 and DBD-Pg-1.01 versions and I am unable to
> access the DB(postgres) . These were installed as per the instructions
> given in the README file. I am beginner in installation.
>
> The line :
> $dbh = DBI->connect("DBI::Pg:dbname=$TEST_REGISTRY");
>
> (where $TEST_REGISTRY ="treg8080"[database name])
>
> is not getting executed.
>
> The problem is that I am not getting any error message also in the
> logfile.
>
> Is something wrong with the DynaLoader or anything else?
>
> Can anyone help me ?
>
> #################
> FYI :
>
> Summary of my perl5 (5.0 patchlevel 4 subversion 0) configuration:
> Platform:
> osname=solaris, osvers=2.5.1, archname=sun4-solaris
> uname='sunos nusrchub 5.5.1 generic_103640-08 sun4u sparc '
> hint=recommended, useposix=true, d_sigaction=define
> bincompat3=y useperlio= d_sfio=
> Compiler:
> cc='gcc', optimize='-O', gccversion=2.7.2.2
> cppflags='-I/usr/local/include'
> ccflags ='-I/usr/local/include'
> stdchar='unsigned char', d_stdstdio=define, usevfork=false
> voidflags=15, castflags=0, d_casti32=define, d_castneg=define
> intsize=4, alignbytes=8, usemymalloc=y, randbits=15
> Linker and Libraries:
> ld='gcc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
> libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
> libc=/lib/libc.so, so=so
> useshrplib=false, libperl=libperl.a
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=, ccdlflags=' '
> cccdlflags='-fpic', lddlflags='-G -L/usr/local/lib'
> ##############
>
> Thanks
> Anuradha
>
>
Thread Next