Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Has anyone used VFPOLEDB to update data ?
Message
De
20/11/2001 09:57:26
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
20/11/2001 09:52:34
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00583878
Message ID:
00583912
Vues:
18
Yes I have that. If I use ODBC driver I can update w/o problems. In an ASP ODBC has the same restrictions, doesn't it ?
Cetin

>Cetin does the IUSER_machine has permission to write in the directory where the tables is located if not the the file is open only has readonly causing the error that you are getting.
>
>>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform