Query Times Out in Stimulsoft but run fine in SSMS

I have this query (which uses linked server as well) runs fine in SQL Server Management Studio (local and remote) but when run in Stimulsoft, it times out. It takes under 5 seconds to run in SSMS but times out in Stimulsoft each time. I did increase timeout period to 90 but still has this issue. I am not sure what is the problem?

exec SPR_HRM_GetSalaries @FromDate=’01-Jun-15′, @ToDate =’25-Jun-15′

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s