"Invalid Buffer Received from Client" when using BigInt parameter vs Int

  • Thread starter Thread starter James Ankrom
  • Start date Start date
J

James Ankrom

Why would this fail(using int64/BigInt):

Dim mParmValue As System.Int64 = 133

Dim mParm As New System.Data.SqlClient.SqlParameter("@UserID",
System.Data.SqlDbType.BigInt)

mParm.Value = mParmValue


(fails on dataadapter.fill)


When this works fine (using int16/int):

Dim mParmValue As System.Int16 = 133

Dim mParm As New System.Data.SqlClient.SqlParameter("@UserID",
System.Data.SqlDbType.Int)

mParm.Value = mParmValue



Connecting to SQL Server 7.0, getting error 17805 "Invalid Buffer Received
from Client", and "A severe error occurred on the current command" . What am
I missing here?



Thanks,



Jim
 
Back
Top