Problem with transactions in MTS.

From: <hebbe_at_my-deja.com>
Date: Mon, 04 Oct 1999 16:47:49 GMT
Message-ID: <7talng$8oq$1@nnrp1.deja.com>

I have a problem getting the components in MTS work with transactions. We are using MTS 2.0 WinNT 4.0 and Oracle 8.0.5.

We have been using this environment for some time now and it seems like this problem is periodical.

I have two components in MTS, one that handle the calls to the database and one that uses the first component do make some changes in the database. If I let one of the components have the Transaction property “Does not support transactions” the call to the database works fine. But if I try to do the same call to the database with the Transaction property “Supports transactions” on both components then I get an error from the Microsoft OLE DB provider for ODBC Drivers (

Error: 		-2147168246
Description: 	[Microsoft][ODBC driver for Oracle][Oracle]ORA-00000:
normal, successful completion
Source: 	Microsoft OLE DB Provider for ODBC Drivers)

It looks like Oracle does not report any errors.

I have configured the MSDTC to use an NT account which has local administrator rights and is also defined as user in Oracle.

This is the code that execute the SQL-call. It fail in the .Open call. (But only when both components has the Transaction property set to "Support transactions")
Public Function changeQuery( ByVal sSql As String) As Long

Dim sConnection as String
Dim cn As ADODB.Connection

sConnection = "driver={Microsoft ODBC for Oracle};server=etest_db;uid=/;"

Set cn = New ADODB.Connection

With cn

.ConnectionString = sConnection
.Open
.Execute sPSQL, changeQuery, adCmdText + adExecuteNoRecords
.Close

End With
Set cn = Nothing
End Function

Does anyone have any suggestions what I’m doing wrong? Any help would be appreciated.

Best regards,

Øyvind Habberstad

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 11:47:49 CDT