Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC connectivity from AIX (oracle) to MSWindows (SQL Server 2005)

657701Jun 3 2009 — edited Jun 15 2009

Hi All -

I have a problem whereby I am trying to connect OWB with SQL Server 2005. The problem statement follows: -

Infrastructure: -
OWB Server installed on AIX
Oracle Installed on AIX
SQL Server 2005 source on Windows
OWB Client on windows XP

My problem is: -

I am trying to connect OWB with SQL Server 2005 for which I have to create heterogenous source entry in Oracle home. But AIX box does not have any ODBC drivers installed and hence I can not configure a DSN on the same. Can any one suggest where can I get these drivers and their installation steps.

Thanks in advance!

Arun

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2009

Added on Jun 3 2009

#heterogeneous-connectivity

5 comments

5,471 views