This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We have a powerbuilder application which connects to SQL Server 2008 database. We have some reports which run around 3-4 hours. This is via a procedure invoked from the application code. when this long report runs, the application is getting disconnected from the database after 1 hour 40 minutes.
We have the below timeout parameters set in the connection string from application:
Connect timeout = 6000, TimeOut = 6000,CommandTimeOut = 6000
When we increased the CommandTimeOut Parameter to a higher value, the reports were completed with out database disconnect. But the performance was reduced. ie the reports are taking more time when we increased the value of CommandTimeout parameter in the connection string.
Could you please let me know what is the best solution for this issue.
***Post moved by the moderator to the appropriate forum category.***
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi Shiras,
Your Microsoft SQL Server 2008 question is more complex than what is typically answered here in Microsoft Answers forums. It is better suited for the IT Pro audience on TechNet. Kindly post your question in the TechNet Microsoft SQL forum.
For further queries, feel free to post back.
I have posted it on TechNet. Thank you.
