RE: How to query an oracle table from a mysql database
You may want to look into using a programming language such as C or Java that communicates between both databases. -Original Message- From: Alonso, Claudio Fabian To: '[EMAIL PROTECTED]' Sent: 7/7/04 8:14 AM Subject: How to query an oracle table from a mysql database Importance: High Good morning, I need a MySQL database to be able to query a table in an Oracle database of a remote host. Is this possible? Could anybody tell me how to do it or where to find this information? Thanks in advance, --Claudio .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to query an oracle table from a mysql database
Try PHP, it has built in functions to access both DBs HTH Steve Victor Pendleton wrote: You may want to look into using a programming language such as C or Java that communicates between both databases. -Original Message- From: Alonso, Claudio Fabian To: '[EMAIL PROTECTED]' Sent: 7/7/04 8:14 AM Subject: How to query an oracle table from a mysql database Importance: High Good morning, I need a MySQL database to be able to query a table in an Oracle database of a remote host. Is this possible? Could anybody tell me how to do it or where to find this information? Thanks in advance, --Claudio .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to query an oracle table from a mysql database
Steve et al: If you want to do it right select a programming language such as Java or C++ There are enough good OOA/OOD folks out there that you will be able to pick a good Java or C++ Engineer for the same price as PHP Otherwise you will be adding on Disk Storage when your single threaded app starts exhausting memory (including virtual disk drive space in particular) and computer resources in general Keep me apprised, Martin Gainty (cell) 617-852-7822 (e) [EMAIL PROTECTED] (http)www.laconiadatasystems.com From: Steve Davies [EMAIL PROTECTED] To: 'Alonso, Claudio Fabian ' [EMAIL PROTECTED] CC: ''[EMAIL PROTECTED]' ' [EMAIL PROTECTED] Subject: Re: How to query an oracle table from a mysql database Date: Wed, 07 Jul 2004 17:02:59 +0100 MIME-Version: 1.0 Received: from lists.mysql.com ([213.136.52.31]) by mc6-f16.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 7 Jul 2004 09:03:56 -0700 Received: (qmail 31976 invoked by uid 109); 7 Jul 2004 16:01:08 - Received: (qmail 31955 invoked from network); 7 Jul 2004 16:01:08 - Received: neutral (lists.mysql.com: local policy) X-Message-Info: JGTYoYF78jHJy6039BA9f6fM4wGqMq15 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Archive: http://lists.mysql.com/mysql/168573 Delivered-To: mailing list [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] X-Virus-Checked: Checked Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 07 Jul 2004 16:04:00.0836 (UTC) FILETIME=[046E2840:01C4643C] Try PHP, it has built in functions to access both DBs HTH Steve Victor Pendleton wrote: You may want to look into using a programming language such as C or Java that communicates between both databases. -Original Message- From: Alonso, Claudio Fabian To: '[EMAIL PROTECTED]' Sent: 7/7/04 8:14 AM Subject: How to query an oracle table from a mysql database Importance: High Good morning, I need a MySQL database to be able to query a table in an Oracle database of a remote host. Is this possible? Could anybody tell me how to do it or where to find this information? Thanks in advance, --Claudio .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Check out the latest news, polls and tools in the MSN 2004 Election Guide! http://special.msn.com/msn/election2004.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to query an oracle table from a mysql database
Hello Steve, hello Victor, Thanks for your answers. My PHP application needs to see this Oracle table, but as far as I could see PHP has problems with Oracle 9.2.0. I got a conection problem and found in the PHP's bug database that it isn't currently working. As I'm familiar with PHP/MySQL, I'm trying to see the Oracle table through MySQL. That's why I'm thinking on a way to create in MySQL a view (or something similar) that refers to an external database table (in this case, Oracle). I don't know if this kind of solution is possible, using only MySQL to see a remote Oracle table, not including any programming language. --Claudio .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to query an oracle table from a mysql database
No, that isn't possible using mySQL. Try linking PHP with older client libraries (9.0.1, 8.1.5, etc) instead of the newer 9.2 libraries and see if that fixes your problem with PHP. You can download them from otn.oracle.com swany --- Alonso, Claudio Fabian [EMAIL PROTECTED] wrote: Hello Steve, hello Victor, Thanks for your answers. My PHP application needs to see this Oracle table, but as far as I could see PHP has problems with Oracle 9.2.0. I got a conection problem and found in the PHP's bug database that it isn't currently working. As I'm familiar with PHP/MySQL, I'm trying to see the Oracle table through MySQL. That's why I'm thinking on a way to create in MySQL a view (or something similar) that refers to an external database table (in this case, Oracle). I don't know if this kind of solution is possible, using only MySQL to see a remote Oracle table, not including any programming language. --Claudio .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to query an oracle table from a mysql database
At 13:18 -0300 7/7/04, Alonso, Claudio Fabian wrote: Hello Steve, hello Victor, Thanks for your answers. My PHP application needs to see this Oracle table, but as far as I could see PHP has problems with Oracle 9.2.0. I got a conection problem and found in the PHP's bug database that it isn't currently working. As I'm familiar with PHP/MySQL, I'm trying to see the Oracle table through MySQL. That's why I'm thinking on a way to create in MySQL a view (or something similar) that refers to an external database table (in this case, Oracle). I don't know if this kind of solution is possible, using only MySQL to see a remote Oracle table, not including any programming language. It's not. You must use a program as a bridge, as people have been suggesting. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to query an oracle table from a mysql database
A custom MySQL UDF is one solution if you are comfortable with C. Off list question: What sort of `problem` does PHP have with Oracle 9i that is prohibiting you? -Original Message- From: Alonso, Claudio Fabian To: 'Steve Davies' Cc: ''[EMAIL PROTECTED]' ' Sent: 7/7/04 11:18 AM Subject: RE: How to query an oracle table from a mysql database Importance: High Hello Steve, hello Victor, Thanks for your answers. My PHP application needs to see this Oracle table, but as far as I could see PHP has problems with Oracle 9.2.0. I got a conection problem and found in the PHP's bug database that it isn't currently working. As I'm familiar with PHP/MySQL, I'm trying to see the Oracle table through MySQL. That's why I'm thinking on a way to create in MySQL a view (or something similar) that refers to an external database table (in this case, Oracle). I don't know if this kind of solution is possible, using only MySQL to see a remote Oracle table, not including any programming language. --Claudio .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to query an oracle table from a mysql database
Hello Victor, For your off-topic question, my problem is the same as the one described here: http://bugs.php.net/bug.php?id=28680 I can't access using 9.2. They say 9.2 is too new for current PHP versions. I'll install an older version of the Oracle client and try again. If I can't do it I'll be asking for additional ideas :) (I'm pretty comforable with C but I'm not sure what a MySQL UDF is, I've got to find it out). Thanks a lot, --Claudio -Mensaje original- De: Victor Pendleton [mailto:[EMAIL PROTECTED] Enviado el: miƩrcoles 7 de julio de 2004 15:46 Para: 'Alonso, Claudio Fabian '; ''Steve Davies' ' CC: '''[EMAIL PROTECTED]' ' ' Asunto: RE: How to query an oracle table from a mysql database A custom MySQL UDF is one solution if you are comfortable with C. Off list question: What sort of `problem` does PHP have with Oracle 9i that is prohibiting you? -Original Message- From: Alonso, Claudio Fabian To: 'Steve Davies' Cc: ''[EMAIL PROTECTED]' ' Sent: 7/7/04 11:18 AM Subject: RE: How to query an oracle table from a mysql database Importance: High Hello Steve, hello Victor, Thanks for your answers. My PHP application needs to see this Oracle table, but as far as I could see PHP has problems with Oracle 9.2.0. I got a conection problem and found in the PHP's bug database that it isn't currently working. As I'm familiar with PHP/MySQL, I'm trying to see the Oracle table through MySQL. That's why I'm thinking on a way to create in MySQL a view (or something similar) that refers to an external database table (in this case, Oracle). I don't know if this kind of solution is possible, using only MySQL to see a remote Oracle table, not including any programming language. --Claudio .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
high priority messages (Re: How to query an oracle table from a mysql database)
Hi all, Please, do NOT send messages to a public mailinglist as high priority by flagging the email itself. You're sending this message to hundreds/thousands of people. It might be important to you, but not for each recipient. If someone has filters/triggers for important email, he will get quite annoyed to find out it's only an emailinglist message. People WILL read and respond to your message with the high priority flag. With regards, Martijn Tonies -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]