Manual transaction through Lianja ODBC

[naeempk]

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

[barrymavin]

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.

[naeempk]

I submitted my ticket with the Log file attachment. Waiting for a reply.

[HankFay]

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

[naeempk]

I saw it in Roadmap history as

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

What it does and what type of commands are allowed ?

[HankFay]

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

[josipradnik]

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

[yvonne.milne]

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