Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle -> SQL Server

RE: Oracle -> SQL Server

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Wed, 03 Oct 2001 05:18:51 -0700
Message-ID: <F001.003A03F3.20011003051518@fatcity.com>

What did you use for the generic connectivity? Merant?

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863  

-----Original Message-----
Sent: Wednesday, October 03, 2001 1:25 AM To: Multiple recipients of list ORACLE-L

Generic connectivity works fine, I have tried this. You can query MS SQL server tables, but if you want to execute packages/procedures of SQL server then you have to use Transparent Gateway for MS SQL server. This is a separate product by oracle. (you can get more details about this at www.oracle.com/gateways

As for as using HSODBC(heterogeneneous ODBC or Generic connectivity) if your database in ORACLE, then ODBC driver for SQL server has to be used on UNIX. MERANT is one such provider (www.merant.com).

regards
sunil s.

-----Original Message-----
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au] Sent: Wednesday, October 03, 2001 6:45 AM To: Multiple recipients of list ORACLE-L

Christopher,

What OS is your Oracle DB on?

If on NT and your version >= 816 then you can use the heterogeneous services
- for some more information see Metalink / doco:

I found note 114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic Connectivity using ODBC"
Also note 109730.1 - How to setup generic connectivity (Heterogeneous Services) for Windows NT

If your Oracle is on Unix then you could also use Heterogeneous services,
provided you can get a SQL Server ODBC driver for Unix.

Regards,
Bruce Reardon

-----Original Message-----
Sent: Wednesday, 3 October 2001 7:25

I was thinking that same thing as the easiest way as I know transparent isn't cheap and there probably isn't an easy way.

I was going to use Perl/Java to make something if there isn't any other way
like the OPENQUERY option in SQL Server to look at oracle tables.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863  

-----Original Message-----
Sent: Tuesday, October 02, 2001 4:14 PM
Cc: cspence_at_FuelSpot.com

Oh geez, here I go again.

This is trivial with Perl, DBD::Oracle and DBD::ODBC.

Whether it is useful to you depends on a number of things.

Since it's temporary, this may work for you.

Jared  


I know there is a way in SQL server to query oracle tables, is there a way
to do the reverse?

I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database.

Anyone have any ideas on this, I searched technet (ms/oracle) and metalink,
as well as some search engines without luck.

Christopher R. Spence
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: SUNILSHIVAPPA
  INET: SUNILSHIVAPPA_at_infy.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christopher Spence
  INET: cspence_at_FuelSpot.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 03 2001 - 07:18:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US