No, mysql cannot connect to other database servers, it can't even connect
to other mysql servers except through replication.
John Halladay wrote:
>
> Connecting to the tables in MySQL works fine. For example I can connect to
> the MySQL tables using MS Access. I would like to know if it is possible to
> connect to the tables of another database from MySQL. So instead of going
> from MS Access to MySQL I would go from MySQL to an AS400.
>
> Do I somehow use the command CONNECT [] to change the database?
>
> -----Original Message-----
> From: Scott Baker
> To: John Halladay; MySQL List (E-mail)
> Sent: 1/31/2001 2:09 PM
> Subject: Re: MyODBC - but how?
>
> You just create a DSN in the control panel, and tell your ODBC compliant
>
> software to use that data source.
>
> At 11:46 AM 1/31/2001 -0700, John Halladay wrote:
> >I have just installed MyODBC on my machine (Windows ME) and everything
> is
> >working fine, but I've looked through the manual and I can't find
> anything
> >showing commands on how to connect to other databases. Can someone
> point me
> >in the right direction?
> >
> >Thanks.
> >
> >John Halladay
>
> -------------------------------------
> Scott Baker - Webster Internet - Network Technician
> 503.266.8253 - [EMAIL PROTECTED]
>
> "Children today are tyrants. They contradict their parents, gobble their
>
> food, and tyrannize their teachers." - Socrates
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
