Results 1 to 4 of 4

Thread: Vfp database

  1. #1
    Junior Member
    Join Date
    Sep 2014
    Posts
    5

    Vfp database

    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

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,369
    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

  3. #3
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,369
    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

  4. #4
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,933
    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

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us