How to handle double byte data??
 

Dear all,

I have an Excel macro which retrieves double data from a AS400 database
using ADO connection.

cnn.Open "Provider=IBMDA400;Data Source=myAS400Machine;", "", ""

Suppose the name of my result recordset is myRst, even when I use msgbox
to see the value in the record set (Msgbox myRst.Fields("myField"), I got the
following error:

Run-time error '-2147467259(80004005)':
Converted 24 bytes, 2 errors found beginning at offset 0

I am so frustrated by this problem. Can anyone advise how to solve it??
Thanks in advance.

Ivan