Yup, Thanks a lot. This is exactly the solution what i want. Thank you very much. :)
----- Original Message ----- From: "Kardos András" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 23, 2004 5:20 AM Subject: Re: Direct connection to mysql database > You can use one DSN, and then use the SQL command "USE databasename" to > switch to other databases on the same server (if you have the right). > > "alice" <[EMAIL PROTECTED]> wrote in message > news:<[EMAIL PROTECTED]>... > Hi, all > > I would like to know is there anyway where i can connect to the mysql > database without add the odbc dsn ? which i want to direct access to the > mysql database. i wish to create 1 dsn, and by using this dsn, i able to > access all database, > even able to create/delete the mysql database. > > is there anyway to do that ? > > Thanks. > > Regards, > Alice > ---------- > > > > > /---------------------------------------------------------------------------\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--------------------------------------------------------------------------/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]