VB Prodigy Tutorial (continued) Introduction to--ODBC data source

Source: Internet
Author: User
Tags connection pooling dsn connect odbc visual studio

This article welcomes the non-commercial use of reprint, but need to indicate from the "Programming Network" and the corresponding URL link.

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. In My computer, open Administrative Tools in Control Panel, and the ODBC Data source icon is visible in the window.

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.

See a full set of "VB Prodigy Tutorials" (continued)

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.