query processing

[mazhar_007]

hey there,
I trying to process an sql query which has an encryption function in it but at runtime it gives an error saying :

Conversion from type 'Byte()' to type 'String' is not valid.

I dont know what can be the problem and hence cant debug it..

the code:

Dim ds As New DataSet
Dim da As Odbc.OdbcDataAdapter
Dim sql As String

sql = "select des_decrypt('password','somekey'),id from password where id='bob';"
        da = New Odbc.OdbcDataAdapter(sql, conn)
        da.Fill(ds, "ret")
        str = ds.Tables("ret").Rows(0).Item(0) '[COLOR="Red"]here it gives the error[/COLOR]
        MsgBox(str)

please help!

 

[Never]

you can define the str as byte

Dim str() As Byte