Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can i use SQL Server in VFP 7
Message
From
04/10/2005 08:03:43
 
 
To
04/10/2005 03:05:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01055756
Message ID:
01055793
Views:
12
You can also use OLE DB.

>Yes, you can.
>There is two different ways (at least for VFP7):
>You can get and set the information from SQL DB via Remote Views or with SQL Pass-Through. Take a look in ALL functions that begins with SQL...(). All you need is an ODBC connection to SQL Server or a connection stored in your DBC.
>If you update VFP to 8 or 9 you will have an additional way (the way i love) - CursorAdapters. Then connection can be ODBC or ADO.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform