Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 2005
Message
 
To
15/05/2008 11:58:14
Randy Hooper
Ranco Business Software
Tampa, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
01317337
Message ID:
01317339
Views:
8
>I have been using remote views is this a stable way to go? I am getting time out issues, etc. Is there another way to update Sql Server then using remote views, if so point me in the direction I need to go, or a simple sample if there is one so I can see what is going on.
>
>Thanks

Sure, but it depends what version of VFP you use.
If VFP7 and smaller you could use 2 ways, both ODBC based:
One you already use - RV, second is SQL-PASS through. Check all functions that begins with SQL*() in HELP

In VFP 8 and 9 you have one additional choice-to use CursorAdapters. That way you can use ODBC and ADO based RecordSets to manipulate data. Because CAs can use both technologies.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform