client v7 to connect v8.1 mts error

[mao2192]

Setup:
OS: Windows 2000
DB2 Client 7.2 FP13
Connecting to a DB2 Connect Gateway v8.1 FP8
COM+ Component written in VB6
MDAC 2.8 installed

I have a simple test component that "RequiresTransaction". This is
called by a simple form with one button. When the component is called
it performs the following logic:

on error goto errorhandler
Create connection -> set cursor location adUseClient -> open connection
execute SQL statement (an insert)
GetObjectContext.SetComplete
exit sub
errorhandler:
GetObjectContext.SetAbort
raise error
end sub

This works fine (both committing and rolling back) against DB2 Connect
v7.2 but fails against DB2 Connect v8 on the .execute with the
following error:
[IBM][CLI Driver][DB2] SQL0998N Error occurred during transaction or
heuristic processing. Reason Code = "39". Subcode = "". SQLSTATE=58005

I also tried it with a v8 client on a WinXP box and i get the same
error with a reasoncode of 16 and a subcode 2-80004005 on the
connection.open.

I haven't found a posting on a forum or elsewhere that describes what I
am doing and this particular problem (or a solution to it). Any
thoughts?

[Mark A]

<ma*****@gmail.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...

Setup:
OS: Windows 2000
DB2 Client 7.2 FP13
Connecting to a DB2 Connect Gateway v8.1 FP8
COM+ Component written in VB6
MDAC 2.8 installed

I have a simple test component that "RequiresTransaction". This is
called by a simple form with one button. When the component is called
it performs the following logic:

on error goto errorhandler
Create connection -> set cursor location adUseClient -> open connection
execute SQL statement (an insert)
GetObjectContext.SetComplete
exit sub
errorhandler:
GetObjectContext.SetAbort
raise error
end sub

This works fine (both committing and rolling back) against DB2 Connect
v7.2 but fails against DB2 Connect v8 on the .execute with the
following error:
[IBM][CLI Driver][DB2] SQL0998N Error occurred during transaction or
heuristic processing. Reason Code = "39". Subcode = "". SQLSTATE=58005

I also tried it with a v8 client on a WinXP box and i get the same
error with a reasoncode of 16 and a subcode 2-80004005 on the
connection.open.

I haven't found a posting on a forum or elsewhere that describes what I
am doing and this particular problem (or a solution to it). Any
thoughts?

Sounds like an issue for IBM DB2 software support.