Thanks Bonnie,

That is where I started.... But when I use that technique I get "invalid substring reference" yahta yahta yahta complaints from ADO.

Invalid length parameter passed to the SUBSTRING function

Glenn

>Glenn,
>
>I think it's simply a string .NET data type and a VARCHAR() SQL data type. That's the first thing I would try anyway. <g>
>
>~~Bonnie
>
>
>
>>I am trying to store an DES3 encrypted string from a VB.Net program into a field of a SQL 2005 table using a stored procedure.
>>The final Code which returns the encrypted string is:

>>CipheredValue = Convert.ToBase64String(desdencrypt.TransformFinalBlock(buff, 0, buff.Length))
>>Return CipheredValue
>>

>>
>>My questions are:
>>
>>

What data type is required in SQL 2005 to store this data

>>

What datatype must I use as the parameter in the SP

>>

What data type must I use in the

>>Command.Parameters.AddWithValue()

>>

What datatype should I use in the VB.Net program
>>
>>
>>I sure could use some sage advice.
>>
>>Thanks
>>
>>Glenn