ODBC for ORACLE-SQL on HP-UX

[Edwin Ruiz_2]

Hi!

I want to connect ORACLE Database with SQL SErver using one ODBC under HP-UX. Where can i get this ODBC Software for HP-UX?

Regards!

[H.Merijn Brand (procura · Accepted solution]

If Oracle is running on the HP-UX server, just start the listener with the correct configuration.

Any ODBC client on the mindows side can then talk to Oracle on HP-UX.

I use that to flow data from M$Access on Win2k to Oracle-8.1.7 on HP-UX 11.00 with perl and DBD::ODBC

Enjoy, Have FUN! H.Merijn

[Edwin Ruiz_2]

Thanks Procura!

[H.Merijn Brand (procura]

OK, since that's what you want, some more to save you time to find out yourself:

--8<--- stripped to the minimal needs ...
use strict;
use warnings;

use DBI;

# Making the script dynamic ...
my $mdb = (<*.mdb *.MDB >)[0];

print STDERR "Connecting to the databases ...\n";
my %attr = (
ShowErrorStatement => 1,
PrintError => 1,
RaiseError => 1,
ChopBlanks => 1,
AutoCommit => 0,

LongReadLen => 0x80000,
LongTruncOk => 1,
);
my $RMC = "driver=Microsoft Access Driver (*.mdb);dbq=$mdb";
my $dbm = DBI->connect ("dbi:ODBC:$RMC", "", "", \%attr) or die "$DBI::errstr\n";
print STDERR "Mickey\$oft OK\n";

# From C:\Program Files\Common Files\ODBC\Data Sources\PROLEP ORA a5.dsn
my $ORA = "driver=Oracle ODBC Driver;dbq=leptest;server=leptest";
#'tlo=O;pfc=10;frl=F;rst=T;lob=T;fdl=10;frc=10;fen=T;apa=T;dba=W';
my $dbo = DBI->connect ("dbi:ODBC:$ORA", "PROLEP", "PROLEP", \%attr) or die "$DBI::errstr\n";
print STDERR "Oracle (PROLEP/a5) OK\n";
-->8---

So be sure to have the Oracle dsn, in my case C:\Program Files\Common Files\ODBC\Data Sources\PROLEP ORA a5.dsn) in place. For 8.1.7.4 I had to use an older Oracle client on Win2k (8.1.7.0)

On Windows I found http://fabforce.net/dbdesigner4/ a great help in testing ODBC connectivity and functionality

Enjoy, Have FUN! H.Merijn

[Edwin Ruiz_2]

Do u know the changes that i need to do in oracle side?