Hi Dean,

Windows API contains a set of ODBC functions. They can be helpful for creating ODBC installation and testing utilities.

Some ODBC API functions:

 SQLAllocEnv, SQLAllocHandle, SQLBrowseConnect, SQLConfigDataSource,
 SQLConnect, SQLCreateDataSource, SQLDataSources, SQLDisconnect,
 SQLDriverConnect, SQLDrivers

 SQLFreeEnv, SQLFreeHandle, SQLGetConnectAttr, SQLGetDiagRec,
 SQLGetEnvAttr, SQLGetFunctions, SQLGetInfo,
 SQLGetInstalledDrivers,

 SQLGetPrivateProfileString, SQLInstallerError, SQLManageDataSources   
 SQLNativeSql, SQLSetEnvAttr

FoxPro code samples on News2News site (some of them in members area):

Adding an ODBC data source with the SQLConfigDataSource; use automatic or interactive mode

How to display a dialog box with which the user can add a data source (DSN)

Establishing connection using the SQLDriverConnect

List of ODBC drivers installed (read from the [ODBC Drivers] section)

Enumerating ODBC Data Sources available on the local computer

How to get a list of system DSNs (Data Source Name) with parameters

Retrieveing general information about the driver and data source associated with an ODBC connection

Testing an ODBC connection for supporting specific functionality

Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)

Enumerating ODBC drivers available on the local computer

Retrieving current settings for an ODBC connection

The SQLGetProp() creates a bridge between Visual FoxPro and the ODBC API