Results 1 to 7 of 7

Thread: Problems with ODBC data source and VFP 9 data

  1. #1
    Junior Member
    Join Date
    May 2014
    Posts
    7

    Problems with ODBC data source and VFP 9 data

    I've used the Lianja ODBC Manager to setup a connection to my VFP data and it tests out fine. I've setup a new database in the App Builder and used the option Create Virtual Tables from ODBC. It takes a a few minutes to complete and then I see all of my tables prefaced with "vt_". The problem is though that many of the tables, when clicked on, display a message say "File [vt_tablename] does not exist". A few tables are accessible - seems to be those with a very small number of fields. Is there something I missed?

    Also, in testing a new form, it seems to run properly in all formats until I go into Web App View and Preview in Live Browser. This shows the page, but with no data, and a dialog box shows "Server Connection Lost. The server failed to respond." The strange thing is, all of the demo apps work properly in a browser preview. The common thread between my two issues may be that I am trying to work off of a VFP ODBC data source. At the moment, I don't have the luxury of changing back end databases.

    Thanks for any advice.
    -Matt

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379
    Hi Matt,

    Have a look at the Virtual Tables Troubleshooter - it may be the autoincrement field issue if you are using the VFP ODBC Driver.

    Virtual Table support in the Web Client is on the Roadmap for v1.3. They are currently supported in the Desktop Client only.

    Regards,

    Yvonne

  3. #3
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    The Lianja ODBC Manager is for connecting to Lianja SQL Server data.

    For other data sources you need to use the ODBC driver specific to it.

    in your case you need to use the VFP ODBC driver.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  4. #4
    Junior Member
    Join Date
    May 2014
    Posts
    7
    Ah, I didn't realize auto-inc fields don't work with the ODBC driver -or that virtual table support isn't part of the web client yet. Not a limitation of Lianja, but the ODBC driver's auto-inc issue rules out using native VFP tables for me. Is there a better way to work with existing VFP data?

    Thank you,
    -Matt

  5. #5
    Junior Member
    Join Date
    May 2014
    Posts
    7
    Thanks Barry. I didn't realize that. I did try using the Win32 ODBC driver for setting up a new DSN, but didn't have much luck with Lianja being able to use it. Although, from Yvonne's post, if auto-inc fields are not supported by the VFP ODBC driver, it's a moot point.

    Thanks,
    -Matt

  6. #6
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379
    Hi Matt,

    There is short discussion on other ODBC Drivers for VFP here if you have no option but to keep your data in VFP format. From Hank's reports of testing with these, I think it will depend on the complexity of the queries you need to perform and the speed required whether these will work for you.

    There was also an earlier discussion about interested developers funding a Sponsored Feature for Lianja to support VFP indexes to allow VFP tables to be updated directly from Lianja.

    Regards,

    Yvonne

  7. #7
    Junior Member
    Join Date
    May 2014
    Posts
    7
    Hi Yvonne,

    I'm in the same boat as the earlier discussion about having a sponsored feature. A gradual cut over to Lianja is what I was hoping to do.

    I appreciate the info.
    -Matt

Tags for this Thread

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