Odd error in SQL2K SP4

[wbodger]

I get this error

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

When I run a certain query pulling data with x parameters. I was running a query with a currency parameter, two of which worked just fine, bt when I tried to run it with the third parameter (they were EUR, GBP and USD, respectively) I get the above error. Since it said it was a network error, I tried just RDPing into the box and running it locally, but still got an error. The only thing I changed when the query went from working to not working was chCurrencyCode='GBP' to chCurrencyCode='USD'. Any thoughts?

Willie

 

[mrdenny]

What's the procedure that you are trying to run?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[wbodger]

It is an insert of about 320k records. The query runs fine, but the insert fails. I am running this on a Windows Server 2003 SP2 box. Searching around on the web I found that it might be caused by the TCP/IP Offloading Engine and disabling it should fix the problem (odd because a larger insert had just worked earlier in the day). The only thing I could find about disabling TOE was this line of code

Netsh int ip set disabled

and when I ran it (or tried to anyway) I got the message that the command

int ip set disabled

was not recognized. Any thoughts?

 

[mrdenny]

Are you inserting into a production table, or a table which isn't doing anything? How wide are the records?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[wbodger]

This is a reporting database on my backup sql server. There are just two fields getting inserted, both small fields. One is maybe a varchar 255 and the other is an int and this isn't a new process or setup, just a new problem.

 

[mrdenny]

Run the insert, and then check for locks and blocking. You may find that you are being blocked by someone else.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog