Access Windows MSSQL from hp-ux Oracle

[Paul Sperry]

Greetings all

OK this sounds just crazy to me. All I need
is to access a windows SQL database form my
unix (hp-ux) oracle database.

The windows OS is server 2003 running SQL 2000
The unix OS is hp-ux 11.23 running Oracle 9.2.0.5.0
The unix box is a rx3600 Integrity Itanium.

Under PARISC we used Generic Heterogeneous Services.
But now with our new Itanium 64-bit OS that service is no longer
supported by otacle. I looked into Oracle Transparent Gateway
but the gateway is only certified for older Oracle
releases 9.2.0.8, 10.1.0.5, and 10.2.0.3.

Due to vendor requirements I can't upgrade my oralce.
Surely ther must be another way.

Just woundering what others are doing.

Thanks

[Oviwan · Accepted solution]

Hey

Depending on your requirements you might realize it vice versa. from mssql to oracle?

I have also already checked for ODBC connection without success:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1127245

Regards

[Paul Sperry]

Hi Oviwan

Thanks for the reply. Yes I allready have the Oracle database linked on my SQL server.
But I really need to link the SQL server to the Oracle instance. There's got to be a way. I coulnd't be the only one in this situation. One would think that Oracle and Microsoft would realize the need for this.

Or maybe this is a Micro$oft conspiracy to get people to use SQL instead of Oracle!

[Oviwan]

maybe you can find an answer in oracle forum:

Heterogeneous Connectivity
http://forums.oracle.com/forums/forum.jspa?forumID=63

A similar question of mine
http://forums.oracle.com/forums/thread.jspa?messageID=1841110

Regards

[Paul Sperry]

Looks like I have no choice but to upgrade our oracle. It should be fun fighting with our vendor.

Thanks
for all the input

[Paul Sperry]

thanks again