Microsoft KB Archive/117377

{|
 * width="100%"|

BUG: SqlRpcParam Fails for Some Binary Values

 * }

Q117377

-

The information in this article applies to:


 * Microsoft SQL Server Programmer's Toolkit, version 4.2

-

BUG# 10063 (4.2)

SYMPTOMS
When 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

CAUSE
The 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.

WORKAROUND
Convert the desired binary value to a character string and execute the stored procedure using SqlCmd% and SqlExec%.

STATUS
Microsoft 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

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420