Timeout expired.

Hot Topic

Excel 2007 and OLAP Server Formatting
Want to see which queries are executing in SQL Management studio
SQL2005 Upgrade Advisor's Warning
Users are unable to connect to SQL Server 2005 unless they are in the sysadmin group
How to print labels like label 1 of 1 and label 2 of 3....
Passing array to stored procedure
SQL 2005 Express on Server 2k3 Enterprise
What is the best practice to handle cobol Redeines in flat file data.
ADO Error codes...
HELP accessing SSAS cube from distance

SQL Server

INSERTing a string containing NULL (\0) from PHP app
MDX - Filter by one date dimension and report on another date dimension
Connection String
Sql DB BuiltIn\Power Users role
how to combine text data rows into single row?
Query Notification not fire all subscriptions...
Is there a performance hit if I run with a db on compatibility level 80 in sql server 2005?
Split Function
RS 2005 and Custom Code
Stored Proc for creating and inserting into a table

Timeout expired.

I have a linked server in a local SQL 2000 MSDE database. It connects to a SQL 2005 database on a remote server. When the user tries to download some fairly big binary files he gets the error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

I have written the application in C# 2003 using the .NET framework 1.1. I am using the SqlCommand object and I am setting the timeout to 2700. (I think there was an error setting the timeout to 0). After about 10-15 minutes the timeout error is thrown. Is there something I am missing Could there be something in the remote server that is limiting the connection



Answer this question

Timeout expired.

  • ChrisSmith

    As this is a timeout related to a remote server, it's off-topic for this forum. Moving the thread to a Sql Server forum.


  • Rastogi

    After searching around I found that on the properties page of the SQL 2005 server, under the connections tab there is a Remote server connections group. The "Remote query timeout" was set to 10 minutes.

  • MMMalik

    Hi, Evan

    Please try add "Connect Timeout =120" in your provider string when you create the linked server if it is based on OLEDB provider.

    HTH.

    Ming.

  • Cybertoy

    After changing the timeout on the server the timeout still occured. Does anyone know what else I can change


  • Robert S P

    Just to let everyone know I found the issue. The .mdf file was over 4 GBs. I am not sure why I got a timeout as opposed to a simple message telling me the true error.

  • Eddie Garcia

    The connection was fine. The command is what is timing out.
  • Timeout expired.
Answer this question