JavaScript Editor js editor     Web development 

Main Page

The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces that you can use to access Visual FoxPro databases and tables from other programming languages and applications.

The Visual FoxPro OLE DB Provider includes the following:

You can perform the following functions through the Visual FoxPro OLE DB Provider:

The Visual FoxPro OLE DB Provider is supported by OLE DB System Components as provided by MDAC 2.6 or later. The requirements to run the Visual FoxPro OLE DB Provider are the same as for this version of Visual FoxPro.

When you use Visual FoxPro OLE DB Provider as a SQL Server-linked server, only queries are supported. The Visual FoxPro OLE DB Provider does not support update, insert, or delete operations through a linked server.

Correlation Between Visual FoxPro OLE DB Methods and ODBC Driver Functions

OLE DB and ODBC are different interfaces. No one-to-one correspondence exists between the properties of one interface and the attributes of the other. OLE DB contains a rich definition of property sets and interface method parameters that provide services significantly different from those provided by ODBC.

For more information, see the OLE DB documentation of schema rowsets, property sets, and methods. For a discussion on OLE DB relative to ODBC, see the MSDN article "OLE DB for the ODBC Programmer."

Stored Procedures in the OLE DB Provider

The Visual FoxPro OLE DB Provider acceptsВ stored procedure commands in the following formats:

  • Calling a stored procedureВ using the conventional syntax:

    В Copy Code
    myStoredProc( Param1, Param2, ... )
  • Calling a stored procedure using the SQL EXEC keyword with the following syntax:

    В Copy Code
    EXEC myStoredProc( Param1, Param2, ... ) 
    where each parameter is in the format expected for its data type or is a valid expression that returns that format as in the following example:

    В Copy Code
    EXEC myStoredProc( 'characterparm', {^2002/09/09}, dateTime(), 100, 99.99, .T.)
    Be sure to replace myStoredProc with the name of the stored procedure you want.

    When you are using ADO or ADO.NET and setting the Command Type to Stored Procedure, you do not need to include the EXEC keyword. If the Command Type is not set to Stored Procedure, you must use the conventional syntaxfor stored procedures or use the EXEC keyword.

Registry Entries

When you install the Visual FoxPro OLE DB Provider, the installation program updates your system registry, HKEY CLASSES_ROOT, and adds the following new keys:







International Support

The Visual FoxPro OLE DB Provider provides international language support for the following:

  • Double-byte character sets (DBCS)

  • Multiple collating sequences

    A collating sequence defines the sort order for data stored in a Visual FoxPro table or database. The Visual FoxPro OLE DB Provider is configured to use collating sequences that support the language version of your operating system by default.

See Also

JavaScript Editor js editor     Web development