BUG: SqlRpcParam Fails for Some Binary ValuesLast reviewed: April 29, 1997Article ID: Q117377 |
The information in this article applies to:
- Microsoft SQL Server Programmer's Toolkit, version 4.2BUG# 10063 (4.2)
SYMPTOMSWhen attempting to specify a string of binary data as a parameter in an remote stored procedure (RPC) execution, you may encounter error 10036:
Null destination variable not allowed CAUSEThe function SqlRpcParam will reject attempts to specify a binary parameter if the first byte of the string used as the remote stored procedure parameter is zero.
WORKAROUNDConvert the desired binary value to a character string and execute the stored procedure using SqlCmd%() and SqlExec%().
STATUSMicrosoft has confirmed this to be a problem in DB-Library version 4.20.00. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
|
Additional query words: varbinary SQLBINARY timestamp dblib
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |