Microsoft FoxPro - User's Guide [antikvár]

vii Introduction and Installation The Microsoft® FoxPro® Connectivity Kit* enables you to access data sources and use the information they contain in Microsoft® FoxPro® for Windows™ or Microsoft® FoxPro® for MS-DOS® applications. A data source consists of the data the user wants to access, the database management system (DBMS) and any remote operating system and network necessary to access it. The Connectivity Kit passes your SQL statements to the data source and returns data to a FoxPro cursor or table. With the Connectivity Kit you can build client-server applications that query, update and modify data stored on the data source, as well as perform system administration functions. The Connectivity Kit provides two versions of the FoxPro SQL (FPSQL) function library, one for use with FoxPro 2.5 for Windows and one for use with FoxPro 2.5 for MS-DOS. The two versions of the library share a common function set, so you can write a program to access a remote data source and then run this program in both the MS-DOS and Windows environments. The Windows version of the FPSQL library offers you the advantage of using Microsoft Open Database Connectivity (ODBC) to connect to any data source for which you have installed an ODBC driver. The Connectivity Kit currentiy includes the ODBC drivers for SQL Server and ORACLE®. Your FoxPro for MS-DOS applications can connect to SQL Server data sources. This manual describes the purpose and use of the Connectivity Kit and of the FoxPro functions contained in the FPSQL library, and assumes you have: ¦ Basic knowledge of FoxPro for Windows or FoxPro for MS-DOS as a development tool. ¦ General database knowledge and a familiarity with SQL. ¦ General knowledge about connecting to remote data sources via a network. * Also referred to in this manual as the Connectivity Kit.