Robert Attached is a little doc I wrote-up to install all you need. You can ignore everything from Mod_Perl Prerequisites and below. But in general: 1) You need to install some oracle software on your machine, ask your DBA for a cd or go to technet.oracle.com (signup is free) and download the 8.1.6 (i presume) software. After installing you'll have all the libraries and a pgm called sqlplus (it's just simple sql query tool), it help you get all your connection info straight before writing your perl stuff. Ideally your DBA can do this whole step for you. 2) You can use DBD::Oracle, I don't know of any reason (financial, performance, or otherwise) to use odbc 3) since you will be writing and running your code on your machine (client) and your database is on another machine (server), you need a database account; but, you do not need a Unix account on the database server. HTH Jay ----- Original Message ----- From: "Robert Lopez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 14, 2001 3:28 PM Subject: Re: [Solaris] dbi + DBD:ODBC + ?for oracle? > > > > From: Ivan Adzhubei <[EMAIL PROTECTED]> > > > > Why you intend to use ODBC in the first place? It makes more sense to > > install DBD::Oracle, the DBI module then can use it as a lower level > > interface to DB. This is at least one layer less between your > > application code and the database itself than with the ODBC. To install > > DBD::Oracle you will first need Oracle client files (e.g. binary OCI > > libraries, Net8 libraries, source headers, etc) installed *on the client > > machine* from which you plan to run your Perl DBI code accessing Oracle > > DB, either locally or over the net. Consult your DBA person about the > > availability of the client part of Oracle package. Install and configure > > it properly, you can validate configuration by trying to connect to your > > database server from SQLPlus client run at the same machine. If it works > > -- proceed with building, testing and installing DBD::Oracle. > > Ivan, > > I though it might be a lower cost option for putting in place some > software I will need very infrequently. Almost always always what I > need is in the Informix database. Sometimes if it is not the clues > as to why it is missing are in the Oracle database. > > > > > Robert Lopez wrote: > > > > > > Well I went ahead and ran cpan to install ODBC::Oracle and it says... > > > The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. > > > (The Driver Manager, in turn, needs one or more database specific > > > ODBC drivers. > > > The DBD::ODBC module does _not_ include any ODBC drivers!) > > > so it is pretty obvious I do need at least a driver. Will I need > > > a driver manager? > > > > > > > Well I intend to use DBD::Oracle. I am trying to > > > > clarify what else is needed. Are you saying that > > > > DBD::Oracle does not need to have any other driver > > > > on my Sun workstation in order for me to connect > > > > to the Oracle database on a server elsewhere on > > > > the network? > > > > > > [EMAIL PROTECTED] > > > > -- > > Ivan Adzhubei > > [EMAIL PROTECTED]
<<attachment: oracle-mod_perl.jpg>>
ljstrausslogo.gif