ADO-MTS

[Srinimusuku]

Hi There,
My question is:
*************
I get "Unspecified Error" from the ADO error collection when i try to open a ado recordset object as follows:

dim rst as new adodb.recordset => line1
dim cnn as new adodb.connection =>line2
rst.locktype=adlockbatchoptimistic =>line3
rst.cursortype=aduseclient => line4
cnn.open "conn string to oracle" => line5
rst.open "sql string", cnn => line6

I get "Unspecified Error" when the line6 gets executed. The connection in line5 opens fine.
The code is running under MTS.
I tried lot of trial and error methods but i still get the same error message.
BUT I DO NOT GET THE ERROR WHEN I RUN THE PROJECT IN THE DEBUG MODE(It works fine and gets the data from the Oracle database)
Please tell me the solution as soon as possible.
****************
Thanks,
Srini