From GLoughmiller@presolutions.com Wed, 03 Oct 2001 08:08:07 -0700 From: "Loughmiller, Greg" Date: Wed, 03 Oct 2001 08:08:07 -0700 Subject: RE: Oracle -> SQL Server In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain Or , =gulp= , you could use ASP/COM type objects too..... and use the infamous ODBC... greg -----Original Message----- Sent: Wednesday, October 03, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Hmm, very interesting, that may be a good option. "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 5:20 AM To: Multiple recipients of list ORACLE-L Also, I believe there is JDBC for MSSQL now - previous there was some sort of JDBC-ODBC bridging thing, or something like that. So you could probably use Java stored procedures in Oracle, maybe with a PL/SQL wrapper, and get at your MSSQL data like that via stored procedure calls. Hmm. g -----Original Message----- Sent: Tuesday, October 02, 2001 10:15 PM To: Multiple recipients of list ORACLE-L 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: guy.hammond@avt.co.uk 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@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@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@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: Loughmiller, Greg INET: GLoughmiller@presolutions.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@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).