Results 1 to 8 of 8

Thread: Manual transaction through Lianja ODBC

  1. #1
    Member
    Join Date
    Feb 2012
    Posts
    43

    Manual transaction through Lianja ODBC

    Hi,

    I am using Lianja ODBC from VFP. I tried to set SQLSETPROP(ConHandle,"Transactions",2) to manual setting but it gave me this error

    Warning: The connection transaction mode cannot be set.

    How can I control transaction via Lianja ODBC from other applications ? Does Lianja SQL server "ACID" compliant ?

    Regards
    Naeem

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    Yes it's ACID compliant. Turn odbc tracing on to see what's going on and submit a ticket with the tracing log file so support can look at it.

    Also note that the SQLEXEC() command can be prefixed with lianja to execute any SET commands or other connection initialization.
    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

  3. #3
    Member
    Join Date
    Feb 2012
    Posts
    43
    I submitted my ticket with the Log file attachment. Waiting for a reply.

  4. #4
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,942
    Also note that the SQLEXEC() command can be prefixed with lianja to execute any SET commands or other connection initialization.
    Hi Barry,

    hmm... never heard of that one. Could you illustrate, please?

    thanks,

    Hank

  5. #5
    Member
    Join Date
    Feb 2012
    Posts
    43
    I saw it in Roadmap history as

    ? sqlexec(ConnHandle,"Lianja set date british")

    What it does and what type of commands are allowed ?

  6. #6
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,942
    Hi naeempk,

    good catch.

    And I remember it now.

    Any Lianja command can be run, I believe. Presumably this would include running a prg, which if it return a sysresultset, could return a cursor. I haven't tried it, but it's an interesting thought (a lot of our complex reports do a lot of selects, and then munge the data into a cursor -- having it all run on the server would be neat).

    Thanks for catching it and reminding me.

    Hank

  7. #7
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    Hi Naeempk

    What it does and what type of commands are allowed ?
    Send an SQL statement to an ODBC data source

    Some examples:

    http://www.lianja.com/community/show...ver-RC3-tuning

    http://www.lianja.com/community/show...d-not-editable

    http://www.lianja.com/community/show...-delete-update
    Last edited by josipradnik; 2015-05-18 at 03:09.

  8. #8
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,377
    Please see Lianja ODBC Driver Additional Functionality on the wiki for information on Calling Stored Procedures, Issuing Lianja Commands and Evaluating Expressions.

    Naeem, we have received your tickets and will investigate these.

    Regards,

    Yvonne

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