Inserting string to sql failes using ODBC in VB 6

Hi,

I am trying to insert record in MS Sql database using ODBC in VB 6

The parameters to stored procedure are integer and multiple string values.

e.g

param1:10

param2:"foo"

param3:"bar"

I use byte array to store the values of the string parameter and then put this byte array in variant field.

In odbc I pass this variant to function "SQLBindParameter" to bind each parameter to respective parameter in stored proc .

The integer data passed from application are stored correctly in SQL but string data is causing error.

The strings are not properly stored in SQL.

It is stored as garbage value like arrow or empty string etc..

Please help

TAruna