I appreciate your quick reply. Thanks, Shikha Pandit WHS IT - Clinical Solutions Phone: (847) 964-8709 WHS -> Walgreens Health Services
John Scoles <[EMAIL PROTECTED]> 07/30/2008 07:25 AM Please respond to [EMAIL PROTECTED] To [EMAIL PROTECTED] cc dbi-users@perl.org, [EMAIL PROTECTED], [EMAIL PROTECTED] Subject Re: Questions related to DBI and DBD::Oracle You will have to do all three You will need DBI DBD::Oracle Oracle client and most likely some environment variables as well First actually read the readme files http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.21/README it has detailed instructions on how to set up DBD::Oracle You can use the Oracle Instant client for free and you can get it here http://www.oracle.com/technology/tech/oci/instantclient/index.html cheers John Scoels [EMAIL PROTECTED] wrote: > > Thanks for the input. > I have one more question. If I install oracle.pm will that solve my > problem or do I need to install oracle client on the unix box to make > it work. > Do I need to setup any other environment variables. > > Looking forward for the answers. > > Thanks, > Shikha Pandit > WHS IT - Clinical Solutions > Phone: (847) 964-8709 > > WHS -> Walgreens Health Services > > > [EMAIL PROTECTED] > > 07/29/2008 07:53 PM > > > To > [EMAIL PROTECTED] > cc > dbi-users@perl.org, [EMAIL PROTECTED] > Subject > Re: Questions related to DBI and DBD::Oracle > > > > > > > > > > You will have to install the DBD::Oracle perl module befoer you can > use it. > http://search.cpan.org/~pythian/DBD-Oracle-1.21/Oracle.pm > > so far you only have DBI or th Data Base Interface you need a Data Base > Driver to make it actually connect ot a DB. This is why it is asking for > DBD::Oracle > > > Hello, > > > > I am trying to connect to the oracle database through a perl script. I > > have installed DBI module on my server. > > I need to run my script on an App server and the database is on the > other > > server. > > When I am running the test script which is > > use DBI; > > $dbh = DBI->connect( 'dbi:Oracle:dwhs01', > > 'username', > > 'password', > > ) || die "Database connection not made: > > $DBI::errstr"; > > > > print "Connected to Database"; > > > > It gives me this error. > > install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC > > contains: /usr/opt/perl5/lib/5.8.2/aix-thread-multi > > /usr/opt/perl5/lib/5.8.2 > > /usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi > > /usr/opt/perl5/lib/site_perl/5.8.2 /usr/opt/perl5/lib/site_perl .) at > > (eval 3) line 3. > > Perhaps the DBD::Oracle perl module hasn't been fully installed, > > or perhaps the capitalisation of 'Oracle' isn't right. > > Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge. > > at test.pl line 9 > > > > Please advice what all do I need to setup and install. > > > > Looking forward for the reply. > > Any inputs will be appeciated. > > > > > > Thanks, > > Shikha Pandit > > WHS IT - Clinical Solutions > > Phone: (847) 964-8709 > > > > WHS -> Walgreens Health Services > > > <http://search.cpan.org/%7Epythian/DBD-Oracle-1.21/Oracle.pm>