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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).