RE: MyODBC - but how?
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
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
Re: MyODBC - but how?
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