Hi Rick,
It seems to be caused by WC. I have 2 set of CA classes, one based on SQL and other VFP (cursorschema, select command, conversiofunc ... and the core is same connecting via ADO). Depending on the mode at a time (VFP or SQL) a CA cursor is created using one of the classes. These have been working for quite a time from VFP exe, or as a VFP COM server used in a Silverlight project. With WC however, when I changed mode to VFP it started to give this error. To test it, in the Process method I tried to directly open anyone of them and do nothing. It consistently gives this error and the CA cursor is not opened. Outside WC it works very well. Tried both in COM and File mode but I was desperate might have missed something. Will try again. Note that it works very well if the connection is SQL server, fails with VFPOLEDB.
Update: You were right. It works under file based messaging.
Cetin
>Cetin,
>
>Web Connection does nothing to change the base operation of Visual FoxPro, so whatever the error is, it's not likely to be caused by Web Connection per se...
>
>Are you running in COM mode? File Mode? It's possible that VFP under COM operation behaves differently when dealing with ADO recordsets???
>
>A type conversion usually means that the wrong cursor is open - maybe a work area is switched the wrong way when the import occurs.
>
>+++ Rick ---
>
>>I get this message when I try to create an ADO based cursoradapter against VFP tables:
>>
>>"Type conversion required by the DataType property for field 'Rec_id' is invalid."
>>
>>rec_id is I on source and cursorschema. I get this on every table I attempted to use via a west wind application. Outside WC I don't have this problem. That makes me think that it may be some sort of security (that makes no sense to me). Anyone have fix?
>>TIA
>>
>>Update: The same table also exist on SQL Server. If I switch to SQL server (change connection string and provider in CA connection) it works perfectly well. The problem is with VFPOLEDB and VFP tables.
>>
>>Cetin