RE: Oracle/SQL Server on same box
They can be on the same box but memory and CPU may be an issue since they both like hog each. Dave -Original Message- Sent: Friday, September 27, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they conflict? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: Oracle/SQL Server on same box
yes, but not recommended for busy systems. ok for sandbox though. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:56 AM Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they conflict? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: Oracle , SQL*Server Concurrent SELECT
Title: RE: Oracle , SQL*Server Concurrent SELECT Any Links , Docs on the Same ? -Original Message-From: Shripad Bharati [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:48 AMTo: VIVEK_SHARMASubject: RE: Oracle , SQL*Server Concurrent SELECT U can use Oracle's Heterogeneous Services . -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: 02 April 2002 08:07 To: LazyDBA.com Discussion Subject: Oracle , SQL*Server Concurrent SELECT 2 Databases Exist - 1 in Oracle , 2nd SQL Server AIM To Possibly Run the Following SELECT Query in Some Manner SELECT Oracle Data, SQL Server Data FROM Oracle Table , SQL*Server Table Is the Above possible ? If so How ? Thanks Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html
RE: Oracle , SQL*Server Concurrent SELECT
Title: RE: Oracle , SQL*Server Concurrent SELECT Metalink has some papers and docs on this. Also there is a book called "Oracle Distributed Systems" by Charles Dye. Also, when in doubt you can always RTFM. ;o) Dave -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:03 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle , SQL*Server Concurrent SELECT Any Links , Docs on the Same ? -Original Message-From: Shripad Bharati [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 02, 2002 9:48 AMTo: VIVEK_SHARMASubject: RE: Oracle , SQL*Server Concurrent SELECT U can use Oracle's Heterogeneous Services . -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: 02 April 2002 08:07 To: LazyDBA.com Discussion Subject: Oracle , SQL*Server Concurrent SELECT 2 Databases Exist - 1 in Oracle , 2nd SQL Server AIM To Possibly Run the Following SELECT Query in Some Manner SELECT Oracle Data, SQL Server Data FROM Oracle Table , SQL*Server Table Is the Above possible ? If so How ? Thanks Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html
RE: Oracle - SQL Server
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: [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).
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:[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).
RE: Oracle - SQL Server
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: [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).
RE: Oracle - SQL Server
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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg 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).
RE: Oracle - SQL Server
Title: Oracle -> SQL Server I have not used it but Oracle Transparent Gateway can query against a SQL Server database. This is a very expensive product. Rick -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle - SQL Server 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. "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
RE: Oracle - SQL Server
Title: Oracle -> SQL Server The only thing that I can think of would be the Oracle Transparent Gateway for SQL Server. Although on the surface it appears to be a fairly complex tool, which means it may not be worth the effort over just going ahead and migrating. Just a thought. -::YEX::- ))) -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle - SQL Server 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. "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
Re: Oracle - SQL Server
Sure, Oracle Transparent Gateway for SQL Server. --- Christopher Spence [EMAIL PROTECTED] wrote: 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. 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 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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).
RE: Oracle - SQL Server
There was a transparent gateway for SQL server, but I dunno whether Oracle still maintains it or not. -Original Message- Sent: Tuesday, October 02, 2001 2:41 PM To: Multiple recipients of list ORACLE-L 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. BM__MailAutoSigDo 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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).
Re: Oracle - SQL Server
Title: Oracle -> SQL Server Hi Look into hetereogenous services, at least i had it working on NT. I don't know if this worksfor Unix Jan Benjamins - Original Message - From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 02, 2001 8:40 PM Subject: Oracle - SQL Server 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. "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
RE: Oracle - SQL Server
The white paper about the gateway to SQL server can be found at: http://technet.oracle.com/products/gateways/content.html http://technet.oracle.com/products/gateways/content.html -Original Message- Sent: Tuesday, October 02, 2001 2:41 PM To: Multiple recipients of list ORACLE-L 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. BM__MailAutoSigDo 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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).
Re: Oracle - SQL Server
Hi Christopher, It can be done, Usually from third party software companies. For example, Check out: http://www.datamirror.com/products/tserver/ Back in the day (1996), Oracle had a Mainframe Integration Technologies group that handled such problems. You might want to contact Oracle and see if such a group still exists and if they can provide you with a solution. Regards, Satar --- Christopher Spence [EMAIL PROTECTED] wrote: 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. 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 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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).
RE: Oracle - SQL Server
It is for something which won't have a huge budget as the data is moving over to Oracle eventually, but for now we want access to it. I was thinking about just building a java/perl replication engine for now. It isn't a lot of data. But if there was something pre-packaged it would be nicer. I think the transparent gateway was dropped, either way it is so expensive and out of the range for such a small project. 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: Tuesday, October 02, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi Christopher, It can be done, Usually from third party software companies. For example, Check out: http://www.datamirror.com/products/tserver/ Back in the day (1996), Oracle had a Mainframe Integration Technologies group that handled such problems. You might want to contact Oracle and see if such a group still exists and if they can provide you with a solution. Regards, Satar --- Christopher Spence [EMAIL PROTECTED] wrote: 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. 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 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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).
RE: Oracle - SQL Server
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. 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: Tuesday, October 02, 2001 4:14 PM To: [EMAIL PROTECTED] 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 Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc: pot.com Subject: Oracle - SQL Server Sent by: [EMAIL PROTECTED] om 10/02/01 11:40 AM Please respond to ORACLE-L 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. 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 -- 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).
Re: Oracle - SQL Server
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 Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc: pot.com Subject: Oracle - SQL Server Sent by: [EMAIL PROTECTED] om 10/02/01 11:40 AM Please respond to ORACLE-L 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. 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Oracle - SQL Server
Try to contact the Mainframe Integration Technologies group at Oracle and see what path that takes you. Also, have you tried to see if you can accomplish your goal by shooting the info from SQL server to a table in Oracle, then running a query against that table within Oracle? Did that make sense? I picked the wrong week to stop sniffing glue! Regards, Satar --- Christopher Spence [EMAIL PROTECTED] wrote: It is for something which won't have a huge budget as the data is moving over to Oracle eventually, but for now we want access to it. I was thinking about just building a java/perl replication engine for now. It isn't a lot of data. But if there was something pre-packaged it would be nicer. I think the transparent gateway was dropped, either way it is so expensive and out of the range for such a small project. 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: Tuesday, October 02, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi Christopher, It can be done, Usually from third party software companies. For example, Check out: http://www.datamirror.com/products/tserver/ Back in the day (1996), Oracle had a Mainframe Integration Technologies group that handled such problems. You might want to contact Oracle and see if such a group still exists and if they can provide you with a solution. Regards, Satar --- Christopher Spence [EMAIL PROTECTED] wrote: 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. 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 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh 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).
RE: Oracle - SQL Server
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).
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:[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).