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
