Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command mySQL
Message
From
03/12/2010 20:29:59
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01491709
Message ID:
01491717
Views:
60
This message has been marked as a message which has helped to the initial question of the thread.
>Hi
>
>Anybody has the command lines to connect from VFP to mySQL ?
>
>I need to open a file called xxx.sql, and then export its table to .dbf tables
>
>
>Moises

We connect with the following............
lcConnectionString = "+;
   "Driver=MySQL ODBC 3.51 Driver;"+;
   "Server=< server ip address >;"+;
   "UID=< your Id >;"+;
   "PWD=< your password >;"+;
   "DATABASE=< default schema >;"+;
   "APP=< your application >"

lnConHandle = Sqlstringconnect(lcConnectionString, .T.)
This was in place when I got here so I'm not 100% sure what the "APP" portion is about - I think it is the database while the DATABASE actually points to a schema.
Previous
Reply
Map
View

Click here to load this message in the networking platform