| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle -> SQL Server
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).
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).
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
 |
 |