George, just in case you're not familiar with 'perldoc', here's a little
primer - 'perldoc' is the excellent documentation utility installed when
Perl is installed. Start by doing
perldoc perl
at a command prompt.
As Ron suggested below, to looking up setting environment variables,
do
perldoc perlvar
And, virtually every Perl module comes with a perldoc that describes
how to use that module. For example, to read the excellent DBI
perldocs, after installing the DBI module you would do "perldoc DBI" at
a command prompt. Likewise for the DBD::Oracle module, you would do
"perldoc DBD::Oracle" at a command prompt.
The perldocs are also available online at www.perldoc.com.
And on Windows if you've installed ActiveState Perl, you can get the
perldocs documentation for core modules (and modules installed by ppd)
by going to
Start
- All Programs
- ActiveState ActivePerl 5.8 (or whatever version you have)
- Documentation
HTH.
Hardy Merrill
>>> "Reidy, Ron" <[EMAIL PROTECTED]> 06/24/04 01:01PM >>>
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.
