RE: Problem
- From: Ron.Reidy@xxxxxxxxxxxxxxxxxx (Ron Reidy)
- Date: Thu, 10 Nov 2005 09:11:40 -0700
Is (at least) an Oracle client installed on the computer you are running this Perl program from?
If so, did you properly install DBD::Oracle. Did you read the README* files that are part of the distro?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Fuat Anat [mailto:fuat_anat@xxxxxxxxx]
Sent: Wednesday, November 09, 2005 2:03 PM
To: dbi-users@xxxxxxxx
Subject: Problem
Hi,
I have the following error message when I try to connect to Oracle 10g DB from perl in Linux. Could you please help me.
Best Regards
Fuat Anat
install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis nicht gefunden at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at ./conn.pl line 18
My program is like following
#!/usr/bin/perl -w
# the -w turns on various warnings
use strict; # always code strictly or you'll be sorry!
use DBI;
# create a database handle. the syntax for this is very flexible. # the quoted string second argument is of the form USERNAME/PASSWORD. # if the username is "scott" and the password is "tiger", then # the second parameter would be "scott/tiger". # if you want to connect using OS authentication as the current # unix id then you can omit the username and the password but # leave the slash, so the parameter would then be "/" (as shown).
my $data_source = 'dbi:Oracle:myDB';
my $username = 'user';
my $password = 'pwd';
my $dbh = DBI->connect($data_source, $username, $password)
or die "Database connection not made: $DBI::errstr";
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
.
- Prev by Date: Wish List
- Next by Date: Introduction
- Previous by thread: Problem
- Next by thread: RE: SQL Query Question
- Index(es):
Relevant Pages
|
