sproc error

Results 1 to 2 of 2

Thread: sproc error

  1. #1
    Join Date
    Dec 1969

    Default sproc error

    I have a stored proc in which I declare a variable, id as an intger, I pass id into the calling function and convert it to a long, (cint generates an overflow) and then I get this error message<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type nvarchar to int. <BR>But I&#039ve never suggested in any way that the data be of this type?! It test true to IsNumeric. It converts to a long just fine, and even gives TypeName of long. <BR>Why does the sproc think that it&#039s a nvarchar?!?!?!?

  2. #2
    Join Date
    Dec 1969

    Default RE: sproc error

    Can we see the stored proc code?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts