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.
cancel
Showing results for 
Search instead for 
Did you mean: 

Can Oracle talk to SQL via ODBC?

Gary Seibak
Advisor

Can Oracle talk to SQL via ODBC?

Does anyone know of an inexpensive ODBC Driver that will allow Oracle on HPUX to connect to other databases such SQL Server 2000?

Thanks in advance
5 REPLIES
Steve Steel
Honored Contributor

Re: Can Oracle talk to SQL via ODBC?

Hi

HP Likes

http://www.openlinksw.com/press/hpchange.htm


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Printaporn_1
Esteemed Contributor

Re: Can Oracle talk to SQL via ODBC?

Hi,

ODBC for windows platfrom is free for download at Oracle website.
after down load ,install it with OUI to NT.
COnfigure it in NT control panel.
enjoy any little thing in my life
Rob Bailey_1
Occasional Visitor

Re: Can Oracle talk to SQL via ODBC?

By far the easiest way to connect the two is to have the sqlserver machine odbc'ing to the unix oracle database.

You could then use relication on thr SQLSERVER box to mirror changes down, or trigger events based on data in tables.


Unix/Oracle -> Sqlserver requires 3rd party drivers. I'd feel very worried about relying on 3rd party drivers as I've had bad experiences in the past.
Victor Geere
Frequent Advisor

Re: Can Oracle talk to SQL via ODBC?

If the scenario allows you to do it the other way around SQL=>Oracle then rather do that.
It took me four years to get this working since I tried the first time (and plenty of soap in my mouth), but I cracked it yesterday.

Here's how:

Create a linked server in SQL Server
----------------------------------------
You need the Microsoft OLE-DB driver for Oracle that comes with SQL server. Don't use the Oracle OleDB driver.

You will also need to load the Oracle Client for Windows on the SQL server box.

Then in the SQL server manager console MMC,
under security/linkedservers, add a new server as follows -
Linked server =
Provider Name = 'Microsoft OLE DB provider for Oracle'
Product Name = MSDAORA
Data Source =
That you created and tested with the NET configuration assistant that comes with the Oracle Client, typically "_".

Once you've done this you can access the Oracle server from SQL server in SQL Query analyser as ...

You can even use an Oracle table and a SQL table in the same query! (In trasact-SQL ,my personal favourite)

Let me know if you get stuck. It wasn't easy, but well worth it.



I thought that I was because I had thought.
H.Merijn Brand (procura
Honored Contributor

Re: Can Oracle talk to SQL via ODBC?

Perl has extensive support for both Oracle and ODBC both local and networked.

DBI-1.22 ftp://download.xs4all.nl/pub/mirror/CPAN/modules/by-module/DBD/DBI-1.22.tar.gz
DBD-Oracle-1.12 ftp://download.xs4all.nl/pub/mirror/CPAN/modules/by-module/DBD/DBD-Oracle-1.12.tar.gz
DBD-ODBC-0.41 ftp://download.xs4all.nl/pub/mirror/CPAN/modules/by-module/DBD/DBD-ODBC-0.41.tar.gz

I've used the ODBC drivers to connect three databases at once: Unify/DataServer on AIX 4.3, M$ Access on M$Win2k, and Oracle-7 on HP-UX 11.00
Enjoy, Have FUN! H.Merijn