extending query timeout settings

Question

I have a WPF application that directly communicates with a MS SQL 2008 database.

In the connection string, I have explicitly set the connection time out to be "Connect Timeout=6000", which should give me ten minutes.

I see that my application gives me a timeout error in just a little more than a minute. How can I ensure that I am given 10 minutes to complete my query?

I don't know if there's something missing in my connection string setup or database call, or whether this should be configured from the MS SQL server.

Jonas Arcangel · Accepted Answer · 2011-01-25 00:31:19Z

1

I just checked similar questions here and there's something written about a CommandTimeout. Let me try that first. Thanks!

answered Jan 25, 2011 at 0:31

Jonas Arcangel

1,94514 gold badges58 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harvey Kwok · Accepted Answer · 2011-01-25 00:34:06Z

0

There is a different timeout value for query. If you are using SqlCommand, you can set your timeout value using SqlCommand.CommandTimeout

answered Jan 25, 2011 at 0:34

Harvey Kwok

11.9k6 gold badges41 silver badges59 bronze badges

Comments

Babak Naffas · Accepted Answer · 2011-01-25 00:33:54Z

0

Setting 'Connect Timeout' in your connection string only applies to the opening of your connection to the database. In your query method, you need to set the timeout on your DbCommand object to your connection's timeout.

answered Jan 25, 2011 at 0:33

Babak Naffas

12.6k3 gold badges36 silver badges51 bronze badges

Collectives™ on Stack Overflow

extending query timeout settings

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related