Integrating Visual FoxPro with Appery.io

[abigdreamer]

I have a database either on a server, or on a local work station. Its a Legacy Visual FoxPro app, how do you suggest I sync files between appery.io and the many FoxPro databases?

[Maryna Brodina]

Hello! Could you clarify what do you mean on "sync files between appery.io and the many FoxPro databases"?

[abigdreamer]

The customer isn't going to change their software. So things like car inventory needs to get from the computer the user is talking to, into the mobile form. OLEDB and other integration tools already exist.

If I change a Year, make or model on a mobile device, it needs to have the plumbing to update the clients dbf table.

The database the mobile device starts off with is actually a subset of the main database -- the CARS in inventory -- less than 4000 -- many companies have only 150 or less.

[maxkatz]

Any data source that's exposed as REST API can be used in your app that you create in Appery.io.

If the data is not exposed via REST API, please check http://restxpress.com. It allows to expose any relational data or web service via REST APIs.

[abigdreamer]

HTTP Status 404 - /admin

Ok, I have tomcat installed, do I need to get ahold of them now? Trying to run restexpress and getting this error.

[maxkatz]

[quote:]
do I need to get ahold of them now?
[/quote]
I'm not sure I understand this part...

[Charles Cowens]

Mike,

To help you, we need to find out two things:

1. Which version of Visual FoxPro are you using?

2. Are you using a JDBC driver to connect RESTXpress to FoxPro?

   The RESTXpress forum is over at:

   https://getsatisfaction.com/exadel/pr...

   It might be easier to carry on the conversation over there. It's up to you.

[Alexandr Ancipov]

Hello Mike,

Currently it is impossible to use RESTXpress with Visual FoxPro.
Unfortunately Microsoft (and third parties companies) does not provide jdbc driver for Visual FoxPro.
We tried to use odbc driver via jdbc-odbc bridge but current version (2.0 beta) doesn't support it.
Probably we will add these functionality in next version.

Thanks, Alex

[Jürgen Wondzinski]

Of course there is an JDBC-Driver for FoxPro (or any DBF-based product available.
See http://www.hxtt.com/dbf.html , this Driver is used by most of the Java based products.

[Alexandr Ancipov]

Hello Mike,

We've tested JDBC-Driver for FoxPro from this link:
http://www.hxtt.com/dbf.html
Using this driver we can create datasource same way like for any other JDBC driver.

In /admin ASSETS - DRIVER:
File: DBF_JDBC30.jar
Class: com.hxtt.sql.dbf.DBFDriver

then in DATASOURCE - JDBC
Create new datasource using this driver and URL like this:
dbc:dbf:/c:/mypath/mydatabasefile.dbc

Thanks, Alex