ODBC Functions and the Visual FoxPro ODBC Driver

  • Article

The articles in this section provide a brief summary of ODBC API functions and any Visual FoxPro-specific details.

Note

For general information about ODBC functions, see ODBC API Reference in the ODBC Programmer's Guide.

The ODBC API functions are divided into three main categories here: Core level API functions, Level 1 API functions, and Level 2 API functions.

Note

Several functions behave differently depending on whether the data source is defined as a connection to a directory of free tables (.dbf files) or to a Visual FoxPro database (.dbc file). Certain operations are supported only for database connections.

Core level API support

The ODBC Core level API functions are listed in the following table. All of these functions are supported by the Visual FoxPro ODBC Driver.

Level 1 API Support

The ODBC Level 1 API functions are listed in the following table. All of these functions are fully or partially supported by the Visual FoxPro ODBC Driver.

Level 2 API Support

The following ODBC Level 2 API functions are fully or partially supported:

The following Level 2 API functions aren't supported:

  • SQLBrowseConnect
  • SQLColumnPrivileges
  • SQLDescribeParam
  • SQLForeignKeys
  • SQLNativeSql
  • SQLProcedureColumns
  • SQLProcedures
  • SQLTablePrivileges