Re: FN-FORUM: SQL Server Query Problem

date posted 15th January 2004 13:37

I am using the default connection timeout (which I am guessing is 30
seconds) and I am using the executeReader command in c#. If I change the
timeout to 120 seconds then will this sort this out???

Best Regards

John Kyle

----- Original Message -----
From: "John Kyle" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, January 15, 2004 2:04 PM
Subject: FN-FORUM: SQL Server Query Problem


>
> Hello
>
> I am running a heavy going text search sql server query; I have already
full
> text indexed the tables in question and the query takes about 36 seconds
to
> run completely in SQL query analyzer. However, asp.net this causes
problems
> and spits out the following error:
>
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
responding
>
> Has anybody have any recommendations on how to resolve this issue?
>
> Best Regards
>
> John Kyle
>
>
> --
> ** Get all the Freelance Work you Can Handle *
> The Web Design Business Kit will show you proven tactics
> and strategies for marketing your business, winning bids,
> managing projects and pricing your work. Free Shipping Worldwide.
> Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>