Operating System - HP-UX
1827493 Members
2713 Online
109965 Solutions
New Discussion

Re: ODBC on HPUX (Oracle) to connect to Mickeysoft SQL-Smurfer

 
smookh
Occasional Advisor

ODBC on HPUX (Oracle) to connect to Mickeysoft SQL-Smurfer

Hello, not because I want to, but because some manager heard of it, I have to make a connection to a Windows machine running MS SQL-Server to set up a datapull from the sql server db to one of our Oracle db's. Oracle has something called HS, Heterogenous Services, which is the out of the box cheap solution to do this without having to buy Transparent gateway. HS uses ODBC. Oracle comes with an ODBC agent installed on the Unix box, but you will have to get your own ODBC driver (and driver manager). That's where the problem is, I cannot find a (free) ODBC driver to install on HPUX to connect to sql server, does anybody have this or know where to get it ?
Thanks in advance.

Harm Smook
2 REPLIES 2
curt larson_1
Honored Contributor

Re: ODBC on HPUX (Oracle) to connect to Mickeysoft SQL-Smurfer

you might take a look at:
http://www.iodbc.org/
curt larson_1
Honored Contributor

Re: ODBC on HPUX (Oracle) to connect to Mickeysoft SQL-Smurfer

The DBI perl module defines a set of high level database access interfaces. The DBI interfaces are database independent. The DBI module relies on lower level, database dependent modules for access to particular database systems. The DBD modules provide the database dependent modules. One such module is DBD::ODBC, for access to ODBC data sources.

The DBI and DBD::ODBC modules are available from the Comprehensive Perl Archive Network (CPAN), at:

http://www.cpan.org/CPAN.html#dbd
http://www.cpan.org/CPAN.html#dbi