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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement