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

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