I am having a trouble with the CursorToRS() function of VFPCom.DLL. The RsToCursor() don't transform the none English string, such as "¤¤°ê" Chinese character set, the cursor result is a string of space only.
I don't know what happen with it ?

If you knownd please tell me & thanks very much!

Attached the foxpro code:

#DEFINE C_VFPCOMCLASS 'vfpcom.comutil'
oVFPCOM = CreateObject(C_VFPCOMCLASS)
oRecordSet = CreateObject('ADODB.RECORDSET')
oRecordSet.CursorType = 3 && adOpenStatic Also adOpenForwardOnly
oRecordSet.LockType = 1 && adLockReadOnly
oRecordSet.Open('SELECT name FROM employee ', + ;
'Provider=SQLOLEDB;Password=123;Persist Security Info=True;User ID=usr;Initial Catalog=db_test;Data Source=sqlsvr') && the name is chinese name.
nError = oVFPCOM.RSToCursor(oRecordSet,"employee")
BROWSE