Re: [PHP-DB] consult different databases on different machines
Miguel: 1). Are you trying to connect an MS Access database to a MySQL database? 2). Are the databases and servers both/individually remote or local? See if: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm helps you any. Good luck. Russ On Tue, 20 Nov 2001 12:35:29 + Miguel Loureiro [EMAIL PROTECTED] wrote: Hello all, I'm working with 2 different systems ( php/mysql in Winnt and php/mysql in linux machine), and I would like from WinNt machine consult information in linux machine !!! When I make connection i got no problem(since in linux machine had created an user to acess a database like username@% ...), but when I made a simple select I got an error message :impossible to execute select . My question is , is it really impossible to do that (from winnt access linux/mysql database )??? I think not, because if it was impossible I never access database,wright??? Any ideas about that would help. Thanhs for your time -- Best Regards Miguel Joaquim Rodrigues Loureiro #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] consult different databases on different machines
1. He's not trying to connect MS Access to mySQL. He's trying TO ACCESS a mySQL database on a Win-NT machine. 2. Both mySQL servers are remote. -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 6:39 AM To: Miguel Loureiro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] consult different databases on different machines Miguel: 1). Are you trying to connect an MS Access database to a MySQL database? 2). Are the databases and servers both/individually remote or local? See if: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm helps you any. Good luck. Russ On Tue, 20 Nov 2001 12:35:29 + Miguel Loureiro [EMAIL PROTECTED] wrote: Hello all, I'm working with 2 different systems ( php/mysql in Winnt and php/mysql in linux machine), and I would like from WinNt machine consult information in linux machine !!! When I make connection i got no problem(since in linux machine had created an user to acess a database like username@% ...), but when I made a simple select I got an error message :impossible to execute select . My question is , is it really impossible to do that (from winnt access linux/mysql database )??? I think not, because if it was impossible I never access database,wright??? Any ideas about that would help. Thanhs for your time -- Best Regards Miguel Joaquim Rodrigues Loureiro #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: RE: [PHP-DB] consult different databases on different machines
In which case you're best off helping him as I have no idea! Russ On Tue, 20 Nov 2001 08:10:02 -0600 Rick Emery [EMAIL PROTECTED] wrote: 1. He's not trying to connect MS Access to mySQL. He's trying TO ACCESS a mySQL database on a Win-NT machine. 2. Both mySQL servers are remote. -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 6:39 AM To: Miguel Loureiro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] consult different databases on different machines Miguel: 1). Are you trying to connect an MS Access database to a MySQL database? 2). Are the databases and servers both/individually remote or local? See if: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm helps you any. Good luck. Russ On Tue, 20 Nov 2001 12:35:29 + Miguel Loureiro [EMAIL PROTECTED] wrote: Hello all, I'm working with 2 different systems ( php/mysql in Winnt and php/mysql in linux machine), and I would like from WinNt machine consult information in linux machine !!! When I make connection i got no problem(since in linux machine had created an user to acess a database like username@% ...), but when I made a simple select I got an error message :impossible to execute select . My question is , is it really impossible to do that (from winnt access linux/mysql database )??? I think not, because if it was impossible I never access database,wright??? Any ideas about that would help. Thanhs for your time -- Best Regards Miguel Joaquim Rodrigues Loureiro #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] consult different databases on different machines
Right then: * You have 2 remote MySQL DB's on different O/S's * You want one to 'talk' to the other one? errr (whirrr grind..etc) I'm sorry if you've already stated this in your first email, but could you not just query both DB's separatley using mysql_select_db() Using separate DB connections? I guess it depends on the type of query you want from both DB's... I'm sorry but that''s about as far as I can go! Good luck though. Russ On Tue, 20 Nov 2001 14:12:58 + Miguel Loureiro [EMAIL PROTECTED] wrote: Hello Russ: Russ Michell wrote: Miguel: 1). Are you trying to connect an MS Access database to a MySQL database? No, they are both Mysql databases. 2). Are the databases and servers both/individually remote or local? I have 2 database servers, in Winnt apache/php/mysql for win32 and in linux(suse)apache/php/mysql, so they are different ... Thanks for your time. -- Best Regards Miguel Joaquim Rodrigues Loureiro #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: RE: [PHP-DB] consult different databases on different machines
Exactly what I just suggested - hey do we have telepathic abilities or what?? :-) Russ On Tue, 20 Nov 2001 08:21:24 -0600 Rick Emery [EMAIL PROTECTED] wrote: Hey Russ, I'm wondering. Maybe this might work. What do you think?: $server1 = mysql_connect(server_1,user1,password1); $server2 = mysql_connect(server_2,user2,password2); $db1 = mysql_select_db(database1,$server1); $db2 = mysql_select_db(database2,$server2); rick Richard Emery IT Sr. Project Manager (972) 478-3398 -Original Message- From: Rick Emery Sent: Tuesday, November 20, 2001 8:13 AM To: '[EMAIL PROTECTED]' Subject: RE: RE: [PHP-DB] consult different databases on different machines I got no clue either. I'm hoping somebody can, though. rick Richard Emery IT Sr. Project Manager (972) 478-3398 -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:09 AM To: Rick Emery Cc: [EMAIL PROTECTED] Subject: Re: RE: [PHP-DB] consult different databases on different machines In which case you're best off helping him as I have no idea! Russ On Tue, 20 Nov 2001 08:10:02 -0600 Rick Emery [EMAIL PROTECTED] wrote: 1. He's not trying to connect MS Access to mySQL. He's trying TO ACCESS a mySQL database on a Win-NT machine. 2. Both mySQL servers are remote. -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 6:39 AM To: Miguel Loureiro Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] consult different databases on different machines Miguel: 1). Are you trying to connect an MS Access database to a MySQL database? 2). Are the databases and servers both/individually remote or local? See if: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm helps you any. Good luck. Russ On Tue, 20 Nov 2001 12:35:29 + Miguel Loureiro [EMAIL PROTECTED] wrote: Hello all, I'm working with 2 different systems ( php/mysql in Winnt and php/mysql in linux machine), and I would like from WinNt machine consult information in linux machine !!! When I make connection i got no problem(since in linux machine had created an user to acess a database like username@% ...), but when I made a simple select I got an error message :impossible to execute select . My question is , is it really impossible to do that (from winnt access linux/mysql database )??? I think not, because if it was impossible I never access database,wright??? Any ideas about that would help. Thanhs for your time -- Best Regards Miguel Joaquim Rodrigues Loureiro #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] consult different databases on different machines
seems to be a permission problem... you have to give GRANT rights in your database to your winnt IP address Valter Santos - Original Message - From: Miguel Loureiro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 12:35 PM Subject: [PHP-DB] consult different databases on different machines Hello all, I'm working with 2 different systems ( php/mysql in Winnt and php/mysql in linux machine), and I would like from WinNt machine consult information in linux machine !!! When I make connection i got no problem(since in linux machine had created an user to acess a database like username@% ...), but when I made a simple select I got an error message :impossible to execute select . My question is , is it really impossible to do that (from winnt access linux/mysql database )??? I think not, because if it was impossible I never access database,wright??? Any ideas about that would help. Thanhs for your time -- Best Regards Miguel Joaquim Rodrigues Loureiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
