DB2 stored procedures running under MTS

[Marc]

I've got a nasty problem.
1) I invoke a stored procedure (a DB2 stored procedure on a MVS system) through
ADO and it works fine as long as I don't try to include it within a MTS transaction
2) If I invoke the stored procedure as part of a MTS transaction, then I
get the following error:

[IBM][CLI Driver][DB2] SQL0000W Statement processing was successful.

Key: NULL
ErrorType: ADO Error
Description: [IBM][CLI Driver][DB2] SQL0000W Statement processing was successful.
HelpContext: 0
HelpFile: NULL
NativeError: 265946
Number: -2
Source: datEAS_Acct

Which doesn't much appear to be an error at all but it's enough for MTS to
terminate the transaction. Anybody got any ideas on this one?

[MarkN]

What version of ADO, DB2 and what provider are you using?

Other than that, my only suggestions don't use stored procs (you probably
have to) and don't do cross platform data access especially with MS tools.

Mark

"Marc" <mnielse1@wcb.bc.ca> wrote:
>
>I've got a nasty problem.
>1) I invoke a stored procedure (a DB2 stored procedure on a MVS system)
through
>ADO and it works fine as long as I don't try to include it within a MTS
transaction
>2) If I invoke the stored procedure as part of a MTS transaction, then I
>get the following error:
>
>[IBM][CLI Driver][DB2] SQL0000W Statement processing was successful.
>
>Key: NULL
>ErrorType: ADO Error
>Description: [IBM][CLI Driver][DB2] SQL0000W Statement processing was
successful.
>HelpContext: 0
>HelpFile: NULL
>NativeError: 265946
>Number: -2
>Source: datEAS_Acct
>
>Which doesn't much appear to be an error at all but it's enough for MTS
to
>terminate the transaction. Anybody got any ideas on this one?
>

[arun]

"Marc" <mnielse1@wcb.bc.ca> wrote:
>
>I've got a nasty problem.
>1) I invoke a stored procedure (a DB2 stored procedure on a MVS system)
through
>ADO and it works fine as long as I don't try to include it within a MTS
transaction
>2) If I invoke the stored procedure as part of a MTS transaction, then I
>get the following error:
>
>[IBM][CLI Driver][DB2] SQL0000W Statement processing was successful.
>
>Key: NULL
>ErrorType: ADO Error
>Description: [IBM][CLI Driver][DB2] SQL0000W Statement processing was
successful.
>HelpContext: 0
>HelpFile: NULL
>NativeError: 265946
>Number: -2
>Source: datEAS_Acct
>
>Which doesn't much appear to be an error at all but it's enough for MTS
to
>terminate the transaction. Anybody got any ideas on this one?
>
Can you provide the method of connecting to MVS based DB@ using ADO?