Increase Connection Timeout

StrataFrame Forum

Back

Increase Connection Timeout

Author	Message
Bill Cunnien	Bill Cunnien posted 16 Years Ago HOT Topic Details Share Topic
Group: Forum Members Posts: 785, Visits: 3.6K	I have a query that is taking about 90 seconds. The window times out before any data is displayed. How do I increase the connection timeout for this query? Thanks, Bill
	Reply Like 1

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

Increase Connection Timeout

Bill Cunnien - 16 Years Ago

Perhaps I should have title this thread: Increase Query Timeout

Bill Cunnien - 16 Years Ago

Here is the error: "Timeout expired. The timeout period elapsed prior...

Bill Cunnien - 16 Years Ago

Hi Bill, I found a thread that may give you an idea about using a...

Edhy Rijo - 16 Years Ago

Bill, You can set the remote query timeouton the server, I had to...

Paul Chase - 16 Years Ago

Bill, I thought that I had found where to set it on a per query...

Paul Chase - 16 Years Ago

Yeah, Paulnailed it on the last post. The most common timeout that is...

Trent L. Taylor - 16 Years Ago

Thanks Paul and Edhy!! I am still using SQL Server 2000...I will see...

Bill Cunnien - 16 Years Ago

[quote]If the command timeout can be set, how do I do that from the...

Trent L. Taylor - 16 Years Ago

Thanks. Took me a minute to make the right connection from the command...

Bill Cunnien - 16 Years Ago

How do you set the sql command timeout on SF built in calls such as...

Kenneth Langley - 16 Years Ago

I'm not sure how to change the time out, but I'm suspicious that...

Greg McGuffey - 16 Years Ago

I guess I should have said that the clients that are having the...

Kenneth Langley - 16 Years Ago

Wow, I remember when a T1 was a fast connection! :D

You...

Greg McGuffey - 16 Years Ago

More detail, we have a varbinary(max) field with binary data. This...

Kenneth Langley - 16 Years Ago

Hi Bill, You could try putting: Option (Recompile) as the last...

Peter Jones - 16 Years Ago

Hi Bill, Just looked at the code in your post and the line:...

Peter Jones - 16 Years Ago

You may also want to look at your database maintenance plan and make...

Larry Caylor - 16 Years Ago

Guys, sorry for the super delayed response here. We have not been in...

Trent L. Taylor - 15 Years Ago

Hi Trent, When using the Push/Pull methods should the VarBinary fields...

Edhy Rijo - 15 Years Ago

Good point. Yes, they should.

Trent L. Taylor - 15 Years Ago

Trent I cannot find any documentation for the push/pull BLOB...

Kenneth Langley - 15 Years Ago

You can go at this a number of ways, but here is a quick sample. Let's...

Trent L. Taylor - 15 Years Ago

Thanks Trent We have this working well now, thanks for the help...

Kenneth Langley - 15 Years Ago

Cool. It is cool watching it show the progress while updating a single...

Trent L. Taylor - 15 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login