Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Q: no ODBC access to remote MySQL
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Q: no ODBC access to remote MySQL
Miscellaneous
Thread ID:
00827610
Message ID:
00827610
Views:
57
Hi All,

Currently I'm working on VFP app exchanging data with online MySQL database. For security reasons the ISP allows access to the database only from local scripts -- no ODBC connections on port 3306 or any other ports.

I'm bound to this provider and Unix/MySQL -- no way to change it.

I have a temporary solution -- VFP class wrapping SQL command into HTTP request and sending it to PHP script. PHP script performs required operations on the database and sends results back.

More or less it works. Though still I have a feeling that I'm creating what is already created.

May be a library, or control enabling VFP app talking to MySQL through the Internet, any ideas, any info?

Thanks!
Reply
Map
View

Click here to load this message in the networking platform