Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Access Windows MSSQL from hp-ux Oracle

SOLVED
Go to solution
Paul Sperry
Honored Contributor

Access Windows MSSQL from hp-ux Oracle

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
5 REPLIES
Oviwan
Honored Contributor
Solution

Re: Access Windows MSSQL from hp-ux Oracle

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
Honored Contributor

Re: Access Windows MSSQL from hp-ux Oracle

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
Honored Contributor

Re: Access Windows MSSQL from hp-ux Oracle

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
Honored Contributor

Re: Access Windows MSSQL from hp-ux Oracle

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
Honored Contributor

Re: Access Windows MSSQL from hp-ux Oracle

thanks again