[DBNETLIB][ConnectionRead (WrapperRead()).]General network error.

[Sortarius]

Greetings. First time poster here.

I have an ASP page that reads and writes to a SQL db. In my table I have a field with a Text data type. I can without problems work with the field until I hit 2150 characters. After that, every time I try to update the table with more information it gives he the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation.

Searching for this on the net seems like a lot of other people have similar issues, however most of what I can find relates to the Query Analizer rather than an ASP page. I have however tried a fix from Microsoft (add OLE DB Services = -2 to the connection string) as well as tried to modify the ConnectionTimeout = 90. Neither seemed to work.

Anyone have this problem and know a solution?

 

[Sortarius]

Ill only bump this one time.

Has no one seen this problem before?

I am using ASP 3.0 but all of the documentation I can find talks about ASP.NET.

I am really against a wall here and really need help.

 

[Sortarius]

Sorry, I didnt see a way to "edit" this thread rather than posting a reply.

FIX:
It seems the problem relates to only being able to open instance of a table at a time.

What I had done is create a rsListPatients that pulled information from joining 5 tables together. This allowed me to at any time look through this record source to extract information that I wanted.

Since this record source was a grouping of multiple tables, I had then created 5 seperate record sources such as rsGeneral, rsLocation, rsFunding, etc. These are the record sources I used to write into the table with.

I could do this effictively until I hit about 2100 characters in my Text data type field I was using as a log. I do not understand why it worked prior to that but not after.

The fix however was to create a set of arrays to hold patient information from the rsListPatients. After the arrays were populated, I closed the rsListPatients record source. This in effect closed the the connection to the 5 tables, thereby allowing me to go into my table with the Text field and add more than 2100 characters. So far, this has seemed to be a fix. I am now up to over 4000 characters and will expand to more ppl trying to crash it soon.

Anyway, anyone else who has this problem may benefit from this. It has taken me over a day and a half to figure it out. I was at the end of my ropes with this one!

Sort