>Hi, folks,
> I wana create a SQL connection to mysql server with the optional userID and password or database. But it seems I couldn't use the same DSN to reach the mysql datbase. Every new connection with different userid or database, I have to create a new DSN via ODBC administrator by mannually. Obviously, that's importssible to a programm. Is there any idea on this matter? Looking forward your help. Thanks.

Download my ODBC DSN class which has examples on creating connections programmatically.

http://www.mctweedle.com/downloads/odbc_dsn.zip