Shulou(Shulou.com)05/31 Report--

How to use ODBC data source manager and how to add or delete ODBC data sources, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Open database connectivity (ODBC) applications use ODBC data sources to connect to instances of MicrosoftSQLServer. An ODBC data source is a storage definition that records the ODBC driver used to connect to the data source. The following editor explains how to use the ODBC data source manager? How do I add or remove ODBC data sources?

How to use ODBC data Source Manager

Information used by the ODBC driver to connect to the data source.

Options specific to the driver used to connect. For example, a SQLServerODBC data source can record the ISO options to be used, or whether the driver should record performance statistics.

Each ODBC data source on the client has a unique data source name (DSN). The ODBC data source for the SQLServerODBC driver contains all the information for connecting to the SQLServer instance, as well as any basic options.

To configure a MicrosoftSQLServerODBC data source, use the ODBC data source manager. You can start the ODBC data Source Manager by clicking data sources (ODBC) in the Control Panel.

Using the ODBC data source manager, you can

Displays the version information of the SQLServerODBC driver currently installed on the system.

Add, change, and delete data sources for SQLServerODBC drivers.

ODBC data Source Manager can also create tabs for user data sources, system data sources, and file data sources.

The user data source is dedicated to MicrosoftWindows login accounts that are in effect at the time of creation. The user data source is not visible to any other login account. They are also not always visible to applications running as services on the computer.

The system data source is visible to all login accounts on the client. They are also always visible to applications running as services on the computer.

File data sources have been added in ODBC version 3. 0. The file data source is not stored in the system registry, but in the file on the client.

When the data source type is selected, ODBC data Source Manager launches the SQLServerDSN configuration wizard, which guides you through the step-by-step addition of ODBC data sources. Select the desired data source options, such as the database that contains the related tables.

For more information about the ODBC data source manager, see the Windows documentation.

How to add or remove ODBC data sources

You must add an Open Database Connectivity (ODBC) data source to connect ODBC clients to the MicrosoftSQLServer instance. To add a data source, you can use the ODBC data Source Manager (launched by clicking data sources (ODBC) under Administrative tools in Control Panel) and the SQLServerDSN configuration wizard. You can also add data sources programmatically using an ODBCAPI function; however, only advanced users are recommended to use these methods.

You can delete ODBC data sources in the following ways:

Use the ODBC data source manager.

Call SQLConfigDataSource with the fRequest parameter set to SQL_REMOVE_DSN or SQL_REMOVE_SYS_DSN.

Delete the file that contains the data source.

This is the answer to the question about how to use ODBC data source manager and how to add or delete ODBC data source. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.