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 +0000 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]
