>>Using ODBC I can update data from ASP. But whenever I try to use VFPOLEDB instead I get :
>>'Cannot update the cursor' && If used with 'insert into ...'
>>or :
>>'Recordset doesn't support update. ...' && If used Addnew and update.
>>As if it's readonly (or does really provider doesn't support updates from ASP?). I couldn't find much documentation about VFPOLEDB.
>>
>>I should be missing a very basic thing. Simply cannot see it. I've already tried connection.mode = adReadWrite, "Provider ... Mode=ReadWrite;", adUseClient,adUseServer, KeySet, ForwardOnly,Dynamic, Static adLock BatchOptimistic, Optimistic, Pessimistic combinations. Any help is appreciated. TIA.
>
>Cetin, I'm using the OLEDB provider in conjunction with WorldShip, and I've gotten some anomalous behavior in terms of improper insertion of null values and dropped records, but haven't ruled out UPS' app as the cause. I can forward details on the configuration if you need them; it's working in conjunction with a B2B app I'm developing in VFP 7.
>
>>Cetin
Ed,
Thanks. A small routine doing an insert into testdata.dbc from ASP would be enough :)
BTW for nulls problem I changed copy of testdata.dbc I was working for test.
Cetin