An application can be connected to any number of drivers and data sources. These can be a variety of drivers and data sources, the same driver and a variety of data sources, or even multiple connections to the same driver and data source.
Allocating the Environment Handle
The first task for any ODBC application is to load [...]
On computers running Microsoft® Windows NT® Server/Windows 2000 Server, Microsoft Windows NT Workstation/Windows 2000 Professional, or Microsoft Windows® 95/98, machine data source information is stored in the registry. Depending on which registry key the information is stored under, the data source is known as a user data source or a system data source. User data [...]
Data sources usually are created by the end user or a technician with a program called the ODBC Administrator. The ODBC Administrator prompts the user for the driver to use and then calls that driver. The driver displays a dialog box that requests the information it needs to connect to the data source. After the [...]
This tab displays information about the ODBC core components, including the Driver Manager, the cursor library, the installer .dll file, and other files that constitute the core components.
The table below describes the controls on the About tab.
Core component list Displays the description, version, file name, and location of each ODBC core component.
OK Closes the ODBC [...]
Connection pooling enables an ODBC application to reuse a connection from a pool of connections. Use this tab to alter the connection retry wait time and time-out period for a selected driver when using connection pooling. You can also enable and disable performance monitoring, which records a number of connection statistics.
The table below describes the [...]
This tab specifies how the ODBC Driver Manager traces calls to ODBC functions. Tracing is performed by a trace DLL that captures calls between the Driver Manager and either the application or the driver, and then records them in a log file. The Driver Manager can:
• Trace calls continuously or for one connection only
• Perform [...]
This tab displays information about the ODBC drivers installed on your computer. No action can be performed from this tab. You must use the specific driver setup program to add or remove ODBC drivers.
The table below describes the controls on the Drivers tab.
ODBC Drivers Displays the name, version, company, file name, and file creation date [...]
Use this tab to add, delete, or set up file-based data sources that can be shared among all users who have the same drivers installed. These data sources don’t need to be user-dedicated or local to a computer.
The table below describes the controls on the File DSN tab.
File Data Sources Displays all file data source [...]
Use this tab to add, delete, or set up data sources with system data source names (DSNs). These data sources are local to a computer but not user-dedicated. Any user with the correct permissions can access a system DSN.
The table below describes the controls on the System DSN tab.
System Data Sources Lists all system DSNs, [...]
Use this tab to add, delete, or set up data sources with user data source names (DSNs). These data sources are local to a computer and accessible only by the current user.
Below describes the controls on the User DSN tab.
User Data Sources Lists all user DSNs, including the name and associated driver of each. Double-clicking [...]