Vfp database

[dhicks20]

Hi, I am using the trial version of Lianja.

Is there anyway of connecting to an existing backend VFP database?

Or is the only option to import ?

thanks

[yvonne.milne]

Yes, use an ODBC Driver for VFP and Lianja Virtual Tables.

(More on this here : http://www.lianja.com/community/show...pro-data-files)

Regards,

Yvonne Milne

[yvonne.milne]

A few additional notes on this that others may find helpful:

1. The MS VFP ODBC Driver does not support the 'Integer (AutoInc)' data type. If a table has AutoInc fields, the VFP ODBC Driver will report (can be seen in Lianja debug file):

'error=[Microsoft][ODBC Visual FoxPro Driver]Not a table.'

2. The Sybase Advantage ODBC Driver does open tables containing AutoInc fields.

3. In the Sybase Advantage ODBC Driver connection string/DSN, you specify a directory that contains the VFP tables. This will access free tables in that directory and tables in that directory that belong to a database. It will not access tables that belong to the database in that directory but are themselves in another directory.

Couple of useful posts by Hank about the Sybase Driver:

http://www.lianja.com/community/show...se-ODBC-Driver

http://www.lianja.com/community/show...ull=1#post7762

[HankFay]

The big advantage of using the VFP driver is that you will find that complex sql executes just as it does in VFP: optimized and fast. That did not prove to be the case for the Sybase Advantage or the DataDirect drivers, in my testing. Horribly slow (after the first join), in fact. At that time, I had to use a Linux app server, so there was no choice, and other means were found (it was faster to get two cursors into Lianja and then combine them).

Hank