Zeoslib Portal

Just 2 question: 1) With StartTransaction you need Zeos->autocommit = false; before ZEOS->StartTransaction(); Have you missed to paste it? It's not posted as it's set in the component itself through the objectinspector. I only set it manually for the second test. 2) Do in both cases the same error ...

Hi.
As on the sessioncounter, visible on the ms sql db it opens a new session.

This was what was so astonishing.

It may be, that it's a new resultset and the DB thinks it a new session and therefore handle it as one, that I don't know. Nevertheless the DB genereates a new session id.

Really noone who can help?

Noone who have any suggestions? Unfortunately there is no comment in code.

Hi. I need very fast help!! During some tests I did because of problems with transactions, I encountered that the ado-component opens a new session to the ms sql-db every time a select-statement is done. Line 177 in ZDbcAdoStatement.pas if IsSelect(SQL) then begin AdoRecordSet := CoRecordSet.Create;...

Hi all, I have a real big problem. We use ZEOS (6.6.1 - beta) to connect via ADO with a MS SQL Server 2005. (coding with Borland C++ Builder 6). Sometimes it is needed to work with transactions, to have the possibility to rollback when something is wrong with the recently inserted data. For this, wi...