Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MM and 2-tier development with SQL
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00639110
Message ID:
00639112
Views:
31
>
>>In case you haven't seen Bob's FoxTalk article, it describes how VFP can send an SQL statement to MySQL via an ODBC driver and TCP/IP. MySQL returns the results as a read-write cursor which is updated and sent back again. Bob recommends a DNS-less approach using SQLstringconnect() to make the connection. Simple stuff that I'm sure is old hat for you.
>
>>How compatible would the VFP MM framework be with this approach?

That's basically the way the framework supports SQL pass-through. The framework supports using a "named" DSN connection, but I'm sure you could easily use your own connection string. The server could be SQL Server, MySQL, Oracle, or just about anything else.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform