General Network Error

Hi,
I am occasionally getting the above error from an ASP.NET application that i
nserts documents into a SQL database. It had been running without this probl
em for several months and suddenly this problem has raised it's head twice i
n the last few days.
I have narrowed it down to happening when documents are being inserted into
the database, and while this is happening other queries can still be execute
d without any problems - including other inserts.
The full error message is as follows, where line 247 is the insert:
System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandle
dException was thrown. --> System.Data.SqlClient.SqlException: General netw
ork error. Check your network documentation.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at aifl_na.downloadReadingTest2.Page_Load(Object sender, EventArgs e) in c:\
inetpub\wwwroot\aifl-na\Secure\downloadReadingAssessment2.aspx.vb:line 247
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()
-- End of inner exception stack trace --
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain()
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecution
Step.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& comp
letedSynchronously)
The only way Ihave managed to stop this happening is to restart the IIS serv
er that connects to the database. As far as I can tell there is nothing wron
g with the SQL server, could it be a problem with the IIS server it connects
to?
Any suggestions would be greatly appreciated.
Thanks in advance,
Alistair GillespieHi:
As I knowledge, most bug is caused by the code yourself and you have the
call stack, you can see where the error happen is

quote:

---

> at aifl_na.downloadReadingTest2.Page_Load(Object sender, EventArgs e) in

---

c:\inetpub\wwwroot\aifl-na\Secure\downloadReadingAssessment2.aspx.vb:line
247
I suggest you insert a breakpoint at line 247 for
downloadReadingAssessment2.aspx.vb, please check the status at that line and
you may ask in the vb groupnews, because it is not exeception throws by sql
server, after I search in MSDN, it is not error can can handle in vs.net
Best Wishes
Wei Ci Zhou|||You might try running a network monitor trace to see what is going on on
the network when this problem occurs.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Full-Text-Search

Hi,
I have a full-text search enabled table and an image data type column that stores the extracts from the documents stored in the files. I have created a full text catalog that indexes few columns in the table and image data type column as well and I assigned the extension column to this image data type column.
Everything works fine except that search on the image data type column called, in my case "body" does not return anything. The documents exist, there is an information in the "body" column.

My code goes like this:
select FT_TBL.resourceID, FT_TBL.lang, FT_TBL.keywords, FT_TBL.description, FT_TBL.extension, b.rank
from full_text_search as FT_TBL inner join containstable(full_text_search, *, 'Microsoft') as b
on b.[key] = FT_TBL.resourceID
order by b.rank desc

any help appreciated,
thanksI figured the solution to the previous post. I was trying to search on the .pdf files, but I do not have filter installed on the server to filter through these files, other files extension work fine.

Another problem:
I have two tables that are full-text search enabled. And I need to search one table first, and than the columns in the second one. This works fine if the search criteria is found in both tables, but if not the query returns nothing.

help much appreciated!
Thanks|||use union all.