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
