Upgrade Issues - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Upgrade Issues

Author

Topic

rkulseth
Starting Member

3 Posts

Posted - 2005-04-12 : 13:35:18

I resently developed a stock charting system using Java front end, and a SQL2000 backend. Everything was working great. Once the system outgrew running off a SQL instance running of of my devlopment box, I aquired new Server class hardware to run the Database. I had SQL installed, and coppied over my procedures and tables to the new box, and repointed my client to the new box. Whenever I try to call a particular procedure i get the following error


java.sql.SQLException: Procedure or function usp_getbars has too many arguments specified.

I know, i an sending the right number of arguments to the procedure. I captured the string before i sent it to the server and it comes out as follows.


usp_getbars 4,200,1

and here is the header of the procedure in question


SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER  proc usp_GetBars
 @n int,
-- @rc int, 
 @barcount int,
 @symbolID int
AS

SET NOCOUNT ON

--SET ROWCOUNT @rc
SET ROWCOUNT @barcount

...query specifics in here

SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Has anyone seen anything like this? I tried upgrading my JDBC driver, and my MDAC. One more thing, the procedure call runs fine inside the query analyzer.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources