RE: Oracle -> SQL Server

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.

• can you use an Oracl copy of the SQL server data?
• does the data always need to be fresh?
• how fresh?
• how big is it?

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).