topic Re: Can Oracle talk to SQL via ODBC? in Operating System - HP-UX

Can Oracle talk to SQL via ODBC?

Gary Seibak — Thu, 23 May 2002 12:17:15 GMT

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

Re: Can Oracle talk to SQL via ODBC?

Steve Steel — Thu, 23 May 2002 13:31:21 GMT

Hi

HP Likes

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

Steve Steel

Re: Can Oracle talk to SQL via ODBC?

Printaporn_1 — Fri, 24 May 2002 01:36:17 GMT

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.

Re: Can Oracle talk to SQL via ODBC?

Rob Bailey_1 — Fri, 24 May 2002 05:37:44 GMT

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.

Re: Can Oracle talk to SQL via ODBC?

Victor Geere — Fri, 24 May 2002 07:32:24 GMT

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.

Re: Can Oracle talk to SQL via ODBC?

H.Merijn Brand (procura — Fri, 24 May 2002 07:48:01 GMT

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