I use sqlstringconnect without issue.. if you need samples just let me know
Bob Lee
>I know this is a Linux forum but this is probably my best bet for getting a suggestion on this.
>
>I have a MySQL database server installed on my Windows XP box, and it's running fine with an ASP app and the various client utilities.
>
>I can also successfully connect to databases in this server from VFP using a DSN and SQLCONNECT, but each successful connection is accompanied by a dialog/prompt from the ODBC driver (version 3.51), allowing selection of database, specification of username/password, port etc. etc.
>
>I've tried changing the DSN configuration by checking the box for "Don't prompt on connect", but I still get this dialog.
>
>Any idea how to suppress this dialog when connecting from VFP?
>
>Thanks
In the beginning, there was a command prompt, and all was well.