The information in this article applies to:
This article assumes that you are familiar with Microsoft Internet Information Server (IIS) and with creating Active Server Pages (ASP) applications using the programming tools provided with Microsoft Internet Information Server or Microsoft Visual InterDev. Additionally, it assumes that you are familiar with HTML. For more information on Microsoft Information Server and Active Server Pages please see the following Web site: http://www.microsoft.com/iis/default.asp SUMMARYThis article describes how to use ActiveX Data Objects (ADO) on an Active Server Page (ASP) to access data in a Visual FoxPro database. MORE INFORMATIONIn order to run Active Server Pages, you must have access to a computer running Microsoft Internet Information Server version 3.0. If you currently have IIS 2.0, you can download IIS 3.0 from the following Web site: http://www.microsoft.com/iis/default.aspIn order to access a Visual FoxPro database through ADO, you must have the latest Visual FoxPro ODBC driver. To obtain it, go to: http://www.microsoft.com/data/and download the Microsoft Data Access Components, version 2.1.2.4202.3 (GA) or later. For more information about obtaining this driver, please see the following article in the Microsoft Knowledge Base: Q157767 PATCH: Vfpodbc5.exe Visual FoxPro ODBC Driver Version 5.0There are three ways to set up ODBC to access your database over the Internet Information Server:
LimitationsRecordsets, or cursors, generated by Visual FoxPro through the Visual FoxPro ODBC Driver must be of type STATIC, or READONLY. The Visual FoxPro ODBC driver does not support the KEYSET, or DYNAMIC cursor types.ExampleThis example does not use a specific data source. The connect string is being specified in the connection object's Open method. If you do wish to create and use a Data source, ensure it is a System Data Source on the Microsoft Internet Information Server computer.Please RememberChange the SourceDB setting to reflect the Tastrade.dbc on the test system. Ensure the Visual FoxPro ODBC driver version 6.0.8440.01 is installed on the Microsoft Information Server where this Active Server Page is stored. Please see article reference above for availability options of this driver.Contents of the ASP Page
REFERENCES
Additional information on Active Data Object can be found in the following
sources:
Additional query words:
Keywords : kbinterop kbDatabase kbODBC kbVFp300 kbVFp500 kbVFp600 kbGrpFox kbGrpMDAC kbDSupport kbADO210sp2 kbMDAC210SP2 |
Last Reviewed: November 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |