Value can not be converted to requested type.

[SuperDud]

Having a peculiar problem running a MS-SQL 2000 Stored Procedure in CFMX6.1.
SP works perfectly in Query Analyzer and has the right permissions for the web
DSN to execute it. However I keep getting [Macromedia][SQLServer JDBC
Driver]Value can not be converted to requested type. on the last CFPROCPARAM
line when I try and run it in CF. Google on this phrase yields a MS-SQL issue
with non-null properties of fields in the DB. I have gone back and changed all
my fields to accept null values. That has not solved the problem. Am I doing
something stupid? Any insight would be much appreciated. Thanks. S Code
snippets attached..

Stored Procedure
=============
CREATE PROCEDURE sp_InsertNewUser


@txtFName varchar(50),
@txtLName varchar(50),
@txtUserName varchar(50),
@txtPassword varchar(50),
@txtEmail varchar(50),
@txtCode varchar(50),
@intSchoolID int,
@intUserID int OUTPUT

AS

INSERT INTO tblUser (txtFName, txtLName, txtUserName, txtPassword, txtEmail,
intSchoolID, txtCode)
VALUES (@txtFName, @txtLName, @txtUserName, @txtPassword, @txtEmail,
@intSchoolID, @txtCode)

SELECT @intUserID = @@IDENTITY
GO


Code snippet
===========
<cfstoredproc datasource="#DSN#" procedure="sp_InsertNewUser"
returncode="Yes">
<cfprocparam cfsqltype="CF_SQL_CHAR" dbvarname="txtFName"
value="#form.txtFName#" type="In">
<cfprocparam cfsqltype="CF_SQL_CHAR" dbvarname="txtLName"
value="#form.txtLName#" type="In">
<cfprocparam cfsqltype="CF_SQL_CHAR" dbvarname="txtUserName"
value="#form.txtUserName#" type="In">
<cfprocparam cfsqltype="CF_SQL_CHAR" dbvarname="txtPassword"
value="#form.txtPassword1#" type="In">
<cfprocparam cfsqltype="CF_SQL_CHAR" dbvarname="txtEmail"
value="#form.txtEmail#" type="In">
<cfprocparam cfsqltype="CF_SQL_CHAR" dbvarname="txtCode"
value="#form.txtCode#" type="In">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="intSchoolID"
value="#form.intSchoolID#" type="In">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="intUserID"
variable="intUserID" type="Out">
</cfstoredproc>

[byron1021]

Try cfsqltype as cf_sql_varchar and see if that solves the issue. Also try
the return variable as InOut. I think if it's OUT only there may be an issue,
or you could set a default for the value in the proc @intUserid int OUTPUT =
null.