[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:	DEC ODBC Driver
Notice:	DEC ODBC Driver V2.0 Now Available
Moderator:	SQLSRV::MAVRIS

Created:	Tue Dec 29 1992
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1357
Total number of notes:	4864

1318.0. "Not doing BeginTrans... and ACCVIOing executor process." by NOMAHS::SECRIST (Rdb WWS; [email protected]) Mon Mar 24 1997 14:49

    
    Customer using recordsets is not doing BeginTrans...Rollback
    etc. and eventually crashes his executor process for lack of
    PGFLQUOTA.  Claims that if they use BeginTrans...Rollback
    that records are "hard locked" and no one else in system can
    see they, and if they don't they are "soft locked" and
    readable.  I have asked him for a code fragment but don't
    have it yet.  I'm no VB guru -- what is this guy doing wrong ?
    
    Regards,
    rcs

T.R	Title	User	Personal Name	Date	Lines
1318.1	What about the locking especially ?	NOMAHS::SECRIST	Rdb WWS; [email protected]	`Mon Mar 24 1997 18:48`	6
	I'm especially interested in the locking aspects of '.0. Regards, rcs
1318.2		UKVMS3::PJACKSON	Oracle UK Rdb Support	`Tue Mar 25 1997 06:01`	5
	If they don't specify anything then Visual Basic will probably use the ODBC default of automatically committing whenever possible. This would explain the 'softlocking' the customer is seeing. Peter
1318.3	This is logical without a SET TRANSACTION, isn't it ?	NOMAHS::SECRIST	Rdb WWS; [email protected]	`Tue Mar 25 1997 15:31`	6
	Thanks, Peter. Has anybody seen the "lock everybody out of every record I touched" behavior from VB ? Regards, rcs
1318.4		UKVMS3::PJACKSON	Oracle UK Rdb Support	`Wed Mar 26 1997 05:20`	7
	>Thanks, Peter. Has anybody seen the "lock everybody out of every >record I touched" behavior from VB ? Not really, but that is the behaviour I would expect with explicit transaction control. Peter