Multi-Step Operation Error on MTS

[Hagop]

Hi,

We are using a vb application to connect to MTS server that uses a DCOM object that's developed in VB. One of our classes on the MTS Server is bahaving kind of wierdly. When we try to save a transaction the server is returning an error: "Multi-step operations generates error, check status value" error #: -2147217887

We tried every trick in the book still the same problem...

Thank you for your help!

Hagop Hagopian
hhagopian@gsi.ca

 

[JJR]

Does the class contain a ADODB.recordset with an Update method??

Jordi Reineman

 

[dbdfs]

I have the same problem when connected to MySql!

The class does contain an ADODB.recordset with an Update method.

Can anyone help ?

Dominic

 

[axwl]

Client creating the adodb.recordset and passed it to dll reside in the MTS. Please make sure, the adodb.recordset field type doesn't have adBSTR defined, instead use adVarChar with appropriate length. I face the same problem when trying to construct the SQL statement.
The best way is to get the Database structure by executing this SQL and asigned to recordset - select * from <tablename> where 1 = 2