Re: 17805 Starting up Java App server, with SQL Server 2000 Backend

17805 means an invalid buffer was received from the client. This generally
means there's something wrong with your client access software or maybe a
network issue although you would expect a network issue to be more random.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Brent White" <bwhite@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:1148409954.444357.65450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a third-party Java program that has not had problems before, but
the app crashes everytime. I go to the SQL Server log and I see an
error 17805 Severity 20 in the log.

I retried starting the app server with a trace running. It gets this
error doing a cursorfetch from this recordset:



declare @P1 int
set @P1=180150015
declare @P2 int
set @P2=4
declare @P3 int
set @P3=1
declare @P4 int
set @P4=-1
exec sp_cursoropen @P1 output, N'SELECT * FROM GNPMNT10 WHERE MTBNR =
''002'' AND MTPLT = ''01'' AND MTMNU = ''getTACCodeList'' ORDER BY
MTBNR, MTPLT, MTMNU, MTSEL', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4



On another machine running SQL Server 2000 Standard on Win2K advanced,
this does not happen at all. I have no problems and the program works
as normal.

On this system (Win 2003 Standard with SQL Server 2000 Standard) it
gets the 17805 error everytime I try to start the application.

The query set above runs fine in Query Analyzer (it returns no records
except for the "select @P1, @P2, @P3, @P4" statement, but it returns no
records in the existing system, either, except for that last select
statement), and checkdb turns up no problems.

Can someone help me find a place to look?



.

Relevant Pages