Alternatively you can install DBD::Oracle on the DB server (which will presumably have all the relevant Oracle bits) and install and use DBD::Proxy on your client machine.
Even if you use ODBC, you still need the Oracle client underneath it. Cheers, Steve > -----Original Message----- > From: Andy Hassall [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 28 June 2006 8:46 AM > To: [EMAIL PROTECTED]; [email protected] > Subject: RE: Oracle question > > Installing an Oracle client and compiling DBD::Oracle against that is > probably your best bet, particularly on Linux. > > Oracle have a package called Instant Client which is the libraries in a > zip > file; much lighter than the full client install. It's available on > otn.oracle.com. You'll need the "Basic" and "SDK" packages, and preferably > the "SQL*Plus* package too. > > More info in the DBD::Oracle README file and manual page. > > -- > Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk > http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool > > ________________________________ > > From: LLC [mailto:[EMAIL PROTECTED] > Sent: 27 June 2006 23:34 > To: [email protected] > Subject: DBD:Oracle question > > > Hi List; > > I have needs to write a perl DBI script on a Linux host which will pull > data > from an instance of Oracle on a second Linux host. > > Can I grab an Oracle ODBC Driver and reference the driver in my > DBI_>Connect > call or do I have to download and install the Oracle client? > > If ODBC works, any tips on where to get an Oracle ODBC driver for linux ? > > Finally, In either case what should my connect string look like? Here's > what > I have so far, is this correct? > > > # for a box with Oracle client installed for acess to an oracle database > named testdb on hostname myhost.mydomain.com: > my $dbh = DBI->connect("dbi:Oracle:myhost.mydomain.com:testdb", > 'username', > 'passwd' ); > > # for a box with a local Oracle ODBC driver & connection (via .odbc.ini) > with the DNS entry name of ORADB1 > > my $dbh = DBI->connect("dbi:Oracle:server=ORADB1", 'username', 'passwd' > ); > > Thanks in advance for your help
