C
craig love
Guest
OE DataServer MS 11.4. We are getting unexpected behaviour using the Data server into SQL Sever. We can get an exclusive lock on a record via the 4gl, but then the code Releases the buffer it stalls for around 30 minutes and crashes. I am thinking the 30 minutes comes from the default value of -lkwtmo When we selected the record via SQL manager it just sits there "Executing query". So think we have a locking issue. Current thinking is we need to Read-Committed on our queries into SQL server. We specify -Dsrv TXN_ISOLATION,2 on start up and this certainly does set the isolation level be read committed. The problem is when we use the data server it creates multiple odbc connections into SQL and only one of these connections have read-commit set. q1) is it expected that one 4gl connect should spawn multiple odbc connections into sql server (in our case 4)? q2) how do you get all of the connections to have read-committed? currently one 1 of the 4 connections is read-committed). (we have tried sending the sql that sets the isolation level directly but that too only sets 1 of the 4 odbc connections) q3) any other ideas why it stalls trying write data back to sql server? Any help appreciated . Cheers Craig
Continue reading...
Continue reading...