Results 1 to 1 of 1

Thread: Lianja 6.3 now supports oledb drivers as well as ODBC

  1. #1
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    UK, USA, Thailand
    Blog Entries

    Lianja 6.3 now supports oledb drivers as well as ODBC

    In Lianja 6.3 "oledb" can be used as an alternative to "ODBC" with Virtual Tables.

    You can now use the "vfpoledb" driver to access VFP data concurrently while VFP is.

    This is windows specific but enables you to run Lianja Apps alongside VFP applications sharing the data.

    In the CONNSTR of the Virtual Table you specify the CONNSTR (Connection String) of an oledb driver like this:

    use orders connstr "oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=c:\users\barrymavin\northwind.dbc;Exclusive=No" as select * from orders where customerid='BLONP'
    use customers connstr "oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=c:\users\barrymavin\northwind.dbc;Exclusive=No" 
    This creates a VT connected to the VFP database northwind using the VFP oledb driver.

    Records can be updated concurrently with VFP through the UI or using the Lianja/VFP REPLACE statement.

    Data is buffered and Lianja handles optimistic locking in the same way as it does with ODBC.

    The advantage of using oledb rather than ODBC is that Lianja will fetch data as needed rather than fill the cursor when the VT is opened.

    VFP itself buffers records so if you want to see any data that was updated in Lianja you should SET LOCK ON in your VFP code which causes all records to be force read from disk. if your VFP code uses RLOCK() (which is not needed in Lianja as it handles automatic record locking) then that always rereads the active record so you will see changes to it made by Lianja.

    Note that Lianja does not yet handle the sharing of "G" datatypes with VFP (Images etc) but will soon.

    You can lookup oledb and ODBC connection strings at:

    Name:  Screen Shot 2021-09-21 at 2.11.54 PM.jpg
Views: 39
Size:  120.6 KB

    Currently Lianja converts data to uff-8 as that is the universal data format it uses across desktop and web apps.

    I will be adding VT properties to better handle customization of this.
    Last edited by barrymavin; 2021-09-23 at 05:17.
    Principal developer of Lianja, Recital and other products

    Follow me on:




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