Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is ODBC the only way to connect VFP to MySQL?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
SAMBA Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01634952
Message ID:
01635016
Views:
76
Good point. The mySQL databases that I connected to were very small so I never encountered server-side issues. I do recall tat there were a couple of settings in the ODBC Manager that I had to set which made a big difference - I had the similar experience with an Oracle ODBC connection just a few months ago.

>Or some indeces. Or more memory for the db server. Or some other optimization.
>
>>The ODBC should be fine. If you are having a performance problem then the ODBC setting may not be correct or maybe the SQL statements are pulling too many records ??
ICQ 10556 (ya), 254117
Previous
Reply
Map
View

Click here to load this message in the networking platform