General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>i have just got vfp8 and i want to use sqlserver as database.
>how can i do it ?
There is basically one way to talk to SQL Server with native VFP, and that is with SQL Pass-thru (SPT) commands. With SPT you basically make a connection to the server and send commands to it, just like you do when running query analyzer. You can also use Remote Views which do some stuff in the background for you then ultimatly use SPT. VFP SPT uses ODBC drivers.
Finally, you can also use ADO, which is not native to VFP, but a COM server that you can use to access OLE-DB data sources. The new Cursor Adapter in VFP 8.0 makes using ADO much easier than with previous versions. I think the VFP web site has some articles on using the cursor adapter.
BOb
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only