Board index Database Programming

locktype issue from MTS

locktype issue from MTS

Post by kingvita.. » Wed, 20 Sep 2000 04:00:00



hi there.  im having a strange issue with using activeX dlls and ado
recordsets under mts.. it seems when i pass a recordset from one
activex dll to another, the locktype changes from to
adLockbatchOptimistic but ONLY UNDER MTS!  if i set the activex dlls
to "Not an MTS Object" they pass around adLockOptimistic recordsets
just fine.  but as soon as "Uses transaction" or "No transactions" is
set, they change the lock type.. does anyone know if this is by design
or ..?  many many thanks ahead of time.
shawn

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 
Top

locktype issue from MTS

Post by Lin Joyne » Wed, 20 Sep 2000 04:00:00


This is by design. I can't remember the full reasoning behind it, but recall
that it's mentioned in the Microsoft VB courseware.

HTH a bit!
Lin

--
Please reply to newsgroups only :-)


Quote:> hi there.  im having a strange issue with using activeX dlls and ado
> recordsets under mts.. it seems when i pass a recordset from one
> activex dll to another, the locktype changes from to
> adLockbatchOptimistic but ONLY UNDER MTS!  if i set the activex dlls
> to "Not an MTS Object" they pass around adLockOptimistic recordsets
> just fine.  but as soon as "Uses transaction" or "No transactions" is
> set, they change the lock type.. does anyone know if this is by design
> or ..?  many many thanks ahead of time.
> shawn

> Sent via Deja.com http://www.deja.com/
> Before you buy.


 
 
 
Top

1. Newbie MTS/ADO Recordset LockType question

Hi,
I'm realively new to ADO to bare with me.
I'm developing a VB component that will reside within MTS . One of the
methods will return a Recordset object. This recordset object will not be
used to update the recordset.
Should i return a connected readonly recordset or a disconnected readonly
recordset?
If i return a connected readonly  recordset , is the database connection not
returned to the pool even if my method calls SetComplete? Why does it
actually need the connection if it is read only? Will the connection be
returned to the pool when the client of my method frees the recordset?

All info welcome or some good sources of ref.

2. what is the cause that scan type is showing as 'seq scan' after indexing

3. Deadlock issue, MTS & SQL 6.5

4. Data Fragmentation in SQL 7.0

5. DB2 ignores DELETE issued from VB via MTS

6. Wash, DC area - Data Base Designer for Data Warehouse

7. Oracle8.1.6 and MTS lock issue

8. Capturing errors within EXECUTE statement

9. MTS, IIS and SQL Server licence issues

10. Oracle and MTS application DB connection issue

11. Oracle8.0.4 Listener & Microsoft MTS issues

12. MTS/ADO Timeout issue

13. MTS, IIS and SQL Server licence issues


All times are UTC
Board index