
Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,
I believe your error is happening from adBigInt
Try adInteger
Brian A. Manlove
Magenic Technologies Int'l.
Quote:
> paramItemid.Direction = adParamInput
> paramItemid.Type = adBigInt
> paramItemid.Size = 4
> cmdShop.Parameters.Append paramItemid