Oh my !!! Last thing I wanted to hear :) Lemme check with a free table and return to you.
Cetin
>Just remembered, you are using a DBC and not free tables? I recall the OLE DB provider can read free tables OK but would not update.
>
>
>>Thanks Michael. I checked them too and ODBC driver work w/o any problems on same data.
>>Cetin
>>
>>>I've used the provider from ASP and ADO with no problems. Simple connection string "provider=vfpoledb.1; data source=c:\data\test.DBC;" worked fine.
>>>Might be a permission problem with IIS.
>>>
>>>>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