How to set infinite timeout in VC++ MFC when we call stored procedure

0.00/5 (No votes)

See more:

Hi sir
I have an application which is developed in VC 6.0 and it have a stored procedure that i call with some parameter and display the data in an excel sheet.My data is come from SQL Server database.When I execute the stored procedure from database itself it execute fine but when I call the stored procedure from my MFC code then its shows time out error.I am using SQL Server2008 as database and VC6.0 to frontend code.Please give me some code example that I can set the timeout for executing the stored procedure.Please help..

Posted 19-Jan-14 21:56pm

debarunb

Add a Solution

Comments

Richard MacCutchan 20-Jan-14 5:07am

You need to show your code and indicate the point at which the timeout occurs. Please use the Improve question link above, and add the details.

debarunb 20-Jan-14 23:37pm

Hi sir I solved my problem by setting timeout of CDatabase class thanks for ur response...

debarunb 20-Jan-14 23:39pm

SetQueryTimeout()of CDatabase class

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	115
OriginalGriff	85
Dave Kreskowiak	75
Andre Oosthuizen	45
Graeme_Grant	35

Pete O'Hanlon	1,790
OriginalGriff	1,315
Graeme_Grant	810
Richard Deeming	743
Dave Kreskowiak	634

How to set infinite timeout in VC++ MFC when we call stored procedure

Add your solution here

Preview 0

How to set infinite timeout in VC++ MFC when we call stored procedure

Add your solution here

Preview 0

Existing Members

...or Join us