Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP & MySql
Message
From
23/10/2007 11:18:37
 
 
To
23/10/2007 09:26:59
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01262774
Message ID:
01262808
Views:
17
>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~VFPCommandSQLStringConnect
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForMySQL


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform