What are the ODBC data sources in the WIN8 system?

Source: Internet
Author: User
Tags connection pooling dsn odbc

An ODBC (Open database connection) is an application's interface (API). This interface provides the ability to write applications independent of any data management system. OCBC provides a set of application interfaces for different database vendors to special database management systems (DBMS) through an ODBC driver. The user's application uses this set of APIs to schedule an ODBC driver. The driver then contacts the DBMS with the SQL statement.

Let's begin by introducing an ODBC data source. The ODBC Data source icon is visible in the Control Panel system and security management tools.

Double-hit open ODBC data Source Manager, as shown in the following illustration:

The ODBC Data Source Manager provides the most concise way to configure, add, and remove various data source names. It allows users to easily complete the configuration of the data source, and users can delete the original DSN (data source name) or modify the previously configured data source. The specific features of the ODBC Data Source Manager are as follows:

▲ User DSN:ODBC The user data source stores information about how to connect to the specified data provider. User data sources are visible only to the current user and can only be applied on this computer.

▲ System DSN:ODBC The system data source stores information about how to connect to the specified data provider. The system data source is visible to all users on the current machine.

▲ file Dsn:odbc file data source allows users to connect to data providers. File DSNs can be shared by users who have the same driver installed.

▲ drivers: ODBC drivers allow ODBC-enabled programs to get information from ODBC data sources. If you are installing a new driver, use its setup program.

▲ Tracing: ODBC tracing allows you to create logs that invoke ODBC drivers for the technical staff to view or to assist in debugging applications. Visual Studio tracks the ODBC trace that starts Microsoft Visual Studio.

▲ Connection pooling: Connection pooling allows the application to reopen the connection handle, which stores the roundtrip process to the server.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.