Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
If not ODBC, then what?
Message
De
14/03/2005 09:52:24
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
12/03/2005 23:17:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00995148
Message ID:
00995464
Vues:
17
This message has been marked as the solution to the initial question of the thread.
I don't know of a special link. There are plenty of sources with VFP help. Also check for CA builder in downloads (Mark McCasland's).
Cetin

>I figure out that it means Cursor Adapter. That technology is new to me, any link?
>>I sue parametric views, just getting the data I need. What do you mean by CA VFP?
>>
>>>No, I didn't say I use RVs and huge data w/o a problem, I said ODBC serves well. I don't use RVs but SPTs (and/or direct nonquery commands, stored procs and UDF) and didn't have any problem. Backend data huge but you don't request the whole data (sometimes might get over VFP limits). Maybe you're not using parametric views?
>>>If you change to ADO cursors rewrite is a lot. However upgrading to VFP8,9 and using CA VFP would handle for you.
>>>Cetin
>>>
>>>>Hi Cetin.
>>>>I can change the version to VFP 8 or 9. But, you use ODBC and RV's in applications with huge user and data loads with no problem? I checked carefully my app, looking for possible optimizatios but mi problem is random. The computer just freezes at any time (sometimes 5-10 times a day, without giving me errors. I have the latest SPs , for VFP and the OS. Have you experienced something similar?
>>>>Also,supposing that I change my voewf for ADO cursors......what would be the amount of rewrite neccesary?
>>>>
>>>>Thanks Cetin (long time no see)
>>>>
>>>>>
>>>>>With Remote Views you don't have any chance other than ODBC. ODBC serves very well for me.
>>>>>
>>>>>If you put RV and SPT aside, you can use OLEDB. In VFP6 you'd need ADO then. Starting with VFP8, OLEDB is supported through CursorAdapter.
>>>>>
>>>>>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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform