Re: Row locking in ODBC

From: Kingsley Idehen <72662.3403_at_CompuServe.COM>
Date: 8 Dec 1994 20:38:25 GMT
Message-ID: <3c7qs1$h94$1_at_mhadf.production.compuserve.com>


Hi There,

OpenLink Software is shipping a High Performance ODBC Driver for Oracle that doesn't require SQL*Net.
This Driver is also equipped with a very sophisticated "Session Rules Book", enabling the you to integrate DBMS specific features not catered for by your ODBC compliant application. VB does not use the API call SQLSetConnectOption to instruct ODBC Drivers to work in Manual Commit mode.

Our "Session Rules Book" will allow you designate VB as an exception application, by enforcing MANUAL COMMIT MODE for your VB session,in the case of TABLE LOCKING & ORACLE OPTIMISATION GOAL configuration the "Session Rules Book" also comes in handy as you can enforce :-
1) ROW SHARE, ROW EXCLUSIVE, SHARE UPDATE, SHARE, SHARE ROW EXCLUSIVE, and EXCLUSIVE lockmodes
2) You can enforce or switch OPTIMISATION GOALS such as :-

   FIRST_ROWS, ALL_ROWS, RULE, CHOOSE. For more information contact OpenLink Software : Email: 72662.3403_at_compuserve.com

Tel: +44-181-681-7701 Fax: ++44-181-7702
Tel: +44-181-681-7701 Fax: ++44-181-7702
Tel: +44-181-681-7701 Fax: ++44-181-7702

-- 
Kingsley Idehen
OpenLink Software
Received on Thu Dec 08 1994 - 21:38:25 CET

Original text of this message