dbrpcparam datalen problem

[guangxiren@gmail.com]

Hi, there

I have this data binding in the C code:
char szCounter[1025];
....
pSql->BindCharParam( 12,"@Counter",s zCounter,TRUE,1 024);

I got a problem regarding the length of the datalen of dbrpcparam when
I tried to use it for the store procedure call:
dbrpcparam(..,S QLVARCHAR,..,10 24, (BYTE *) szCounter)

When I used 1024 as the datalen, the store procedure call failed, but
if I changed the datalen to 256:
dbrpcparam(..,S QLVARCHAR,..,25 6, (BYTE *) szCounter),
it worked just fine!

The store procedure:
declare @Counter varchar(1024)
....
CREATE PROCEDURE ..,@Counter varchar(1024) output, ....

The databse is MSSQL.

Thanks!

Zhiyong Lu
guangxiren@gmai l.com