Mssql Timeout Problem

[expired user #7667]'s profile image [expired user #7667] posted 10 years ago in General Permalink
Tried with...
heidisql (8.1.0.4611)32&64, heidisql32(8.3.r4695)
Connecting to a DB with Network Type Microcrap Sql Server (Tcp/Ip,Experimental), not connected to a local DB.

If the query takes longer than about 45Secs then it just get this error...
Sql Error (0): Query Timeout expired.

Can't seem to find any options for this, including the portable_settings.txt

I can't seem to find any where to set this.

[expired user #8435]'s profile image [expired user #8435] posted 9 years ago Permalink
http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.commandtimeout.aspx

As shown, this property needs to be set by the sending application. Please fix. wink I've got queries to very large tables (millions of rows) that are going to require the ability to set the timeout property to '0'
ansgar's profile image ansgar posted 9 years ago Permalink
Just update to the latest build, and you will get a new "Query timeout" setting in the session manager's "Advanced" tab:
[expired user #8435]'s profile image [expired user #8435] posted 9 years ago Permalink
Sweet! Thank you! wink

Please login to leave a reply, or register at first.