By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,585 Members | 2,235 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,585 IT Pros & Developers. It's quick & easy.

client v7 to connect v8.1 mts error

P: n/a
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?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.