Devart Forums

When executing a long running query in dbForge studio, I get the error message, "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding" after about 30 seconds have elapsed.

When I run it in SSMS, it returns results just fine in about a 1.5 minutes.

Where can I increase the timeout for the connection in dbForge?

I've searched these forums as well as looked at the connection properties and nothing stands out. Is this changeable?

It can be setup on the 'Advanced' tab of the Database Connection Properties dialog box

I actually found that set of settings and changed both Connection Timeout and Execute Timeout to 0 seconds...meaning, I don't want them to timeout in my dbForge client at all.

However, it's ignoring those settings and continues to timeout at 30 seconds.

Could you please provide us the following:
1. Version of dbForge.
2. Version of the SQL Server.
3. Screenshot of the error and the 'Advanced' tab of the Database Connection Properties dialog box.
4. Log file:
- Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
- Navigate to the 'Environment -> Output' branch.
- Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
- Unselect the 'Delete application log after closing' option. Click 'OK'.
- Reproduce the issue and send us the *.log file with the latest date from the folder: A video would be also of help.

You can send the reply straight to our support system at supportATdevartDOTcom.

Could you please provide us the following:
1. Version of dbForge.
2. Version of the SQL Server.
3. Screenshot of the error and the 'Advanced' tab of the Database Connection Properties dialog box.
4. Log file:
- Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
- Navigate to the 'Environment -> Output' branch.
- Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
- Unselect the 'Delete application log after closing' option. Click 'OK'.
- Reproduce the issue and send us the *.log file with the latest date from the folder:
%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\

A video would be also of help.

You can send the reply straight to our support system at supportATdevartDOTcom.

Email sent to support with information asked for.

We have received it and will answer you as soon as possible.