George, 1. Setting environment variables - perldoc perlvar 2. Using DBI, DBD::ODBC, DBD::Oracle - perldoc DBI, perldoc DBD::ODBC, perldoc DBD::Oracle
For Oracle connectivity issues, see the Oracle Networking docs or your friendly neighborhood DBA ----------------- Ron Reidy Senior DBA Array BioPharma, Inc. -----Original Message----- From: HSIA, GEORGE (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 10:45 AM To: Hardy Merrill; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: DBI_DSN, DBD-Oracle & ODBC Examples? Thanks Hardy, Dennis, and Jeff, I have corrected my path and got all (DBI, DBD-Oracle, DBD-ODBC) installed successfully(under c:\Perl\site). I also appreciate two other gentlemen's emails this morning from dbi-user group. 1) How do I setup the DBI_DSN environment variable for my Perl and Oracle db residing locally on my pc? 2) Do you have a short Perl example using DBD-Oracle to call DBI->connect(????????) and DBI->prepare(???) and DBI->execute(???)? 3) Another example using the DBD-ODBC to call DBI->connect(????????) and DBI->prepare(???) and DBI->execute(???)locally? Thanks all again. George -----Original Message----- From: HSIA, GEORGE (SBCSI) Sent: Thursday, June 24, 2004 9:31 AM To: 'Hardy Merrill'; [EMAIL PROTECTED] Subject: RE: DBI,DBD-Oracle install for AS Perl URGENT!! Thanks Hardy, I have found my path is not right. I have installed it successfully. Your great help over the cyberspace and another help from Dennis' over the continent(Austria?) is very appreciated!! George 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.