>I have designed an Application in VFP7 with MySql Backend. Every thing is OK. Now I want to install it on Client's Computer where it will run on Net Working. I installed ODBC Drivers on Terminnals and start to creat DSN. It needs database name which does not populates in ODBC Driver Form's Combo Box. If I write the name of Database if gives error message of Incorrect Database Name.
>
>Please guide what I have to do.Don't use DSN, which you have to create and maintain on each workstation. It is better to use a DSNLess connection, created in code in your program.
For MySQL it would be something like:
nHandle = SQLStringConnect("Driver={mySQL};" +;
"Server=db1.database.com;" +;
"Port=3306;" +;
"Option=131072;" +;
"Stmt=;" +;
"Database="+cDatabaseName+";" +;
"Uid="+cUsername+";" +;
"Pwd="+cPassword)
See:
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnecthttp://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForMySQL