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

[Michael Widenius]

>>>>> "Pat" == Pat Sherrill <patrick@stripped> writes:

Pat> Sorry, but to the best of my recollection, it's one DSN to one database.  In
Pat> Windows, the DSN basically gives you another way to find your ODBC
Pat> configuration for a given connection in what is intended to be a consistent
Pat> manner, no real magic here.  You can, of course have multiple tables within
Pat> that database.  What exactly are you trying to achieve?

Hi!

One can of course always use the 'use database' command to switch
databases any time!

Another solution is to always refer to tables with the
'database.table' syntax,

Regards,
Monty