DB2 stored procedures running under MTS


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: DB2 stored procedures running under MTS

  1. #1
    Marc Guest

    DB2 stored procedures running under MTS


    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?


  2. #2
    MarkN Guest

    Re: DB2 stored procedures running under MTS


    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?
    >



  3. #3
    arun Guest

    Re: DB2 stored procedures running under MTS


    "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?



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center