>>Hi everybody,
>>
>>I'm currently experimenting with OLEDBFOX.DLL and it looks like it'd be pretty usefull BUT, I'm getting an error when trying to send back the cursor to a RS object (using CursorToRS) so I can send that cursor back to my DataHandler DLL so it updates the backend with any changes done to the cursor.
>>
>>Basically what I'm trying to do is querying SQL2K and have the return into an ADO RecordSet then send that RS to the VFP front-end, do some manipulation on the front-end and send back those updates to the SQL Backend.
>>
>>I managed to get the data to the front-end in a VFP Cursor, but I getting an OLE Error - e06d7363 when trying to convert the updated Cursor to an ADO RS to send back to the DLL.
>
>This code corresponds to internal Visual C++ exception. Could you provide more info to reproduce this error? What's the structure of cursor - number of fields, data types?

Alexander, here is a little bit more info :

Structure is as follow :
id I
cDevice C(3)
cDesc C(30)
cCountry C(20)
cSymbol C(1)

There's only 3 records in that test table, and the only modification I'm doing before trying to send back the updated cursor is a modification in the cCountry field.

I'll add that the cSymbol field can have 2 values right now £ and $. the Rest of the fields are the usual... here's what it looks like right now

1|EUR|Euro|Europe|£
2|CAD|Canadian Dollars|Canada|$
3|USD|United States|United States|$

I'm quite sure it have worked at some point (on the same test table) but it's no longer the case.

I'm using the 'None-Beta' release of your DLL on VFP8/SQL2K.

Thanks for your help.

Have a good one,

Yanick