Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    2

    Unanswered: db hangup when executing SP from C++ using CT lib

    Hi All,

    I am new to ct lib.
    I am executing below statements from a c++ program using CT Libs.

    my storedproc1 is updating one table1 and stored proc2 wants to get the updated data which storedproc updated in table1.

    The application hangs/the storedproc2 hangs here.

    Begin transaction

    exec storedproc1
    exec storedproc2

    Commit transaction

    Any pointers to solve this issue are really helpfull.

    Thanks
    jusva2011

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Have a look in Sybase to make sure that the two stored procedures are not executing on separate connections.

  3. #3
    Join Date
    Jul 2011
    Posts
    2
    Thanks alot for your reply.
    How can i check that two procs are running in one connection or not?

    Thanks
    Jusva2011

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •