Dear Boris, Please note that it is DBD::Oracle version 1.16 -- there is no generic module DBD.
What Ron meant is "Have you ensured that you have installed DBD::Oracle and all its pre-requisites?". Given the error message you are seeing, I strongly suspect you have installed DBD::Oracle itself, but DBD::Oracle (and, specifically, the Oracle.dll generated for DBD::Oracle) needs the Oracle client libraries, and you havenot installed those on your Windows machine (it is often helpful to mention the platform - for example, given that it is Windows, you probably are using an ActiveState build of Perl, rather than one you did, and you probably downloaded DBD::Oracle as well, rather than building it yourself; if you'd built it yourself, you couldn't have done so without the Oracle software, but you probably can install it without the Oracle software when you download the PPM). On 9/9/05, Boris Volf <[EMAIL PROTECTED]> wrote: > > Yes, > DBI version 1.48 > DBD version 1.16 > > -----Original Message----- > From: Reidy, Ron [mailto:[EMAIL PROTECTED] > Sent: Friday, September 09, 2005 2:54 PM > To: Boris Volf; [email protected] > Subject: RE: DBI problem > > Did you install DBD::Oracle? > > -- > Ron Reidy > Lead DBA > Array BioPharma, Inc. > > -----Original Message----- > From: Boris Volf [mailto:[EMAIL PROTECTED] > Sent: Friday, September 09, 2005 12:50 PM > To: [email protected] > Subject: DBI problem > > > Hi, > > > > > > > > I am trying to connect to an Oracle(8) database using DBI module. > > > > I have Perl 5.8.6 installed on my machine with DBI version 1.16, and DBD > > version 1.47. > > > > Below is my program that I am using to connect to the Database > > > > use DBI; > > > > > > > > $db_handle = DBI->connect("dbi:Oracle:dbname", uname, pwd); > > > > $sql_errstr = $DBI::errstr; > > > > $sql_statement = $db_handle->prepare("select * from table"); > > > > $sql_statement->execute; > > > > while(@row = $sql_statement->fetchrow_array) > > > > {print("$row[0]"); } > > > > $db_handle->disconnect; > > > > > > This produces the following error: > > > > > > Install_driver(Oracle) failed: Can't load > > 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll for module DBD::Oracle: > > load_file:The specified procedure could not be found at > > C:/Perl/lib/Dynaloader.pm line230 > > > > > > > > Can anyone help with this? > > > > Thanks, > > > > Boris > > > > > > > ----------------------------------------- > The information contained in this e-mail message and any attachments is > confidential, and is intended only for the use of the party to whom it > is addressed. If you are not the above-named intended recipient, you > are hereby notified that any dissemination, copying or disclosure of > this communication is strictly prohibited. If you have received this > communication in error, please notify Boston Communications Group, Inc. > immediately by reply to this message or by telephoning (781) 904-5000, > and destroy this message and its attachments, without making any copy or > distribution. > > 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. > > -- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
