Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Has anyone used VFPOLEDB to update data ?
Message
 
 
To
20/11/2001 09:08:22
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00583878
Message ID:
00583900
Views:
23
This message has been marked as the solution to the initial question of the thread.
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
Michael McLain
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform