From: info@no-spam-e-resitve.com   
      
   Jim Kennedy wrote:   
   > "DG"  wrote in message   
   > news:d779e901t46@enews3.newsguy.com...   
   >   
   > Sounds like a rollback is being issued or the connection dies and a rollback   
   > is done.   
   >   
   > I would call support.   
   > Jim   
   >   
   >   
      
   The library commits using this function:   
      
   SQLRETURN SQLEndTran(   
   		SQLSMALLINT     HandleType,   
   		SQLHANDLE     Handle,   
   		SQLSMALLINT     CompletionType);   
      
   HandleType is SQL_HANDLE_DBC   
   CompletionType is SQL_COMMIT   
      
   Is committing using this function from ODBC lib not durable?   
      
   Can it happen that the committed data is visible in a parallel   
   connection/session and that at the same time the data can be rolled back   
   to the point before begin of transaction which was committed? If not,   
   then the changes shouldn't be visible in another transaction. I though   
   that if MVCC is used then the changed data will be visible only *after*   
   commit.   
      
   Best regards,   
      
   David   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)