RE: One DSN for multiple databases on a single MySQL server???

[Brian Andrews]

> Is it possible to have one ODBC DSN to handle all of the
> databases on a particular MySQL server?  If so, how do you set
> this up in the ODBC Data Source Administrator, and how do you
> specify which database you want to use durring your ODBC session.

If your using something like VB you can use DSN-less
connections with ADO 2. Search the MyODBC archives
for ADO.



cheers


Brian
+---------------------- I n f o r M a t e ------------------------+
| Brian Andrews      Web Design, Web Hosting       [phone] |
| Director             Software Development        +64 21  OFFICE |
| brian@stripped                    PO Box 33-863 Takapuna |
| http://www.InforMate.co.nz/              Auckland,  New Zealand |
+-----------------------------------------------------------------+

Where am I?  Here:
http://www.expediamaps.com/default.asp?C=-36.7343250087852,174.748856169468&
A=150&OX=0&OY=0&E=P9a462c