If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > db hangup when executing SP from C++ using CT lib

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-06-11, 10:52
jusva2011 jusva2011 is offline
Registered User
 
Join Date: Jul 2011
Posts: 2
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
Reply With Quote
  #2 (permalink)  
Old 07-06-11, 11:37
MCrowley MCrowley is offline
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,899
Have a look in Sybase to make sure that the two stored procedures are not executing on separate connections.
Reply With Quote
  #3 (permalink)  
Old 07-06-11, 20:08
jusva2011 jusva2011 is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On