Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem releasing a Recordset from an MTS Component

Status
Not open for further replies.

richardereyes

Programmer
May 29, 2001
1
US
I have in a visual basic project (Activex Dll) a class module that access a database (sql sever 7) using an ADO Recordset, the problem is when I run the application within Visual Basic the execution Stops when I release the RecordSet (set recs=nothing), and several seconds later it resume executing...

I am working on a Windows 2000 server, and the class has "Require Transaction". If I change this value to "not a MTS Object", the delay doesn´t happen.

The other test I did was compile the dll and create the package in the Component Services, when I run the application referencing the DLL the delay doesn´t happen either. It seems to be a problem with the Visual Basic (6) environment.

I installed the service pack 2 of windows 2000 and the service pack 5 of Visual Estudio, but it didn´t help.

Can anybody help me with this?


Thanks,
Richard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top