So what do I need to do? I ran thru everything this morning again on a different machine.
I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ActiveState Perl 5.8.6. When I had 5.8.6 everything was working fine, so I uninstalled Perl completely and installed 5.8.6 version back again. Using PPM, I downloaded DBD 1.16 and DBI 1.48. And got this error again Let me know if you can help, Thanks, Boris _____ From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Sunday, September 11, 2005 10:02 AM To: Boris Volf Cc: [email protected] Subject: Re: DBI problem 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] <mailto:[EMAIL PROTECTED]> > wrote: Yes, DBI version 1.48 DBD version 1.16 -----Original Message----- From: Reidy, Ron [mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Friday, September 09, 2005 2:54 PM To: Boris Volf; [email protected] <mailto:[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] <mailto:[EMAIL PROTECTED]> ] Sent: Friday, September 09, 2005 12:50 PM To: [email protected] <mailto:[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] <mailto:[EMAIL PROTECTED]> > #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org <http://dbi.perl.org> "I don't suffer from insanity - I enjoy every minute of it."
