Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linux ODBC for VFP
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00634413
Message ID:
00634941
Views:
25
Hi,

When I mentioned a linux file server running samba, what I had in mind was using the standard VFP DBC on a linux file server running samba within a local network. If the topic was about a web server running a linux DBM backend, then my suggestion was off target.

I run a linux web server and have recently moved from MySQL to Postgres. I use the perl DBI called from HTML pages to insert, delete, and update the database. I was able to make the change with very little change to the cgi-bin scripts. If I need to work with the postgres data, I can easily create a comma delimited text file and import it into a VFP table.

Your solution of using a common MySQL or Postgres Datastore, that could be accessed from a web server using perl, PHP, etc, and also be accessed using a VFP application via ODBC within the local network may be a better solution than what I'm currently doing. When I have a little time I plan to play with this an see how it works. By the way I enjoyed your article in Foxtalk "Going Cross-Platform Again: Using Visual FoxPro to Connect to a MySQL Database on Linux".
Leland F. Jackson, CPA
Software - Master (TM)
smvfp@mail.smvfp.com
Software Master TM
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform