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 modeHow to display a dialog box with which the user can add a data source (DSN)Establishing connection using the SQLDriverConnectList of ODBC drivers installed (read from the [ODBC Drivers] section)Enumerating ODBC Data Sources available on the local computerHow to get a list of system DSNs (Data Source Name) with parametersRetrieveing general information about the driver and data source associated with an ODBC connectionTesting an ODBC connection for supporting specific functionalityUsing SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)Enumerating ODBC drivers available on the local computerRetrieving current settings for an ODBC connectionThe SQLGetProp() creates a bridge between Visual FoxPro and the ODBC API