Robin, time ago I had a similar problem with connectin a access MDB and retrive the correct connection string.
Try something similar:
1 - create a DNS file
2 - in your fox project create a new connection
3 - in window connection designer select the "Connection string" option
4 - select the DNS you created and confirm
5 - now the connection designer show the connection string
6 - copy the string and release the designer without saving
7 - paste it in your code at CREATECONNECTION
8 - modify code to substitute user and password in conn. string

hope this help.

>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.