Integrating Visual FoxPro with Appery.io

[abigdreamer]

I am learning more about this driver.
http://www.csv-jdbc.com/stels_dbf_jdb...
Made great progress with general appery knowledge.

[abigdreamer]

So with a jdbc driver you don't need restexpress? How does appery.io connect to FoxPro databases or see in the UI?

[maxkatz]

RESTXpress uses JDBC driver to connect to relational database. Once you establish the connection, you can expose relational data via REST APIs. Once you have APIs, you can use them in an app you build in Appery.io.

[Charles Cowens]

Mike, the comment that you're replying to includes the instructions for setting up the JDBC connection with RESTXpress. It's described in the online user guide http://exadel.com/RESTXpress/RESTXpre... starting at page 7.

[Jürgen Wondzinski6076650]

Just as a sidenote:
When using any of those JDBC-Drivers, be aware that none of them support any database features from a VFP-database like Stored Procedures, Triggers, Default Values etc. That's because in a VFP-Database those routines need a VFP engine to work. Since the JDBC drivers aren't VFP-based, you're only getting raw data-access without any additional functionality or security.

[Jürgen Wondzinski6076650]

Hi Mike, have you tested both DBF Drivers? How do they compare in terms of speed (for example: updating a field in a huge table, or selecting a smal resultset from a huge table). Does it support Rushmore-like query-optimisations?

[abigdreamer]

I haven't gotten this far yet, so far I'm using Activevfp -- but nothing is populating yet. Still early for me.

[abigdreamer]

We are using (Activevfp) https://activevfp.codeplex.com with the iIS BOX at the clients office holding IIS .. and triggers, stored procedures, default values, (ARE supported) oh -- and its FREE!

[abigdreamer]

YEH YEH YEH
Its working
Happy Dance

Proxy was the problem.