cancel
Showing results for 
Search instead for 
Did you mean: 

sql timeout in SDK

Former Member
0 Kudos

Hi,

I am excecuting a storeprocedure wich is taking time more than 10 mins to excecute so in my code its waiting upto 2 mins and saying call failed . so plz help me how to write sql timeout in SDK.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I have got solution for this. Sap doesn't wait if we are not calling any sap object for some time that's why its disconcerting sap. so to resolve this i called storeproc using one asynchronous thread and until the tread is stop i am running one loop in that loop i am calling one sapobje (like oform.level=5). every 3 sec i am calling sap object so sap is alive until storeproc is completed.

Former Member
0 Kudos

Hi,

You may check this link to find one way to achieve your goal:

http://windowsitpro.com/article/articleid/14256/how-do-i-configure-the-client-query-time-out-for-sql...

Thanks,

Gordon

Former Member
0 Kudos

Thank you very much Du,

But i did n't get how to usesql time out in my c# code . plz help me . any sample code......plz