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

[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

 

[James Ankrom]

The answer is... 7.0 doesn't have bigint. d'oh.