distal-attribute
distal-attribute
distal-attribute
distal-attribute

Mssql Timeout Problem

Mat posted 9 months ago in General
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.

RickA posted 5 days ago
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 posted 5 days ago
Just update to the latest build, and you will get a new "Query timeout" setting in the session manager's "Advanced" tab:
RickA posted 5 days ago
Sweet! Thank you! wink

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