ODBC (Open Database Connectivity) 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 to different database vendors for special database management systems (DBMS) through ODBC drivers. The user's application uses this set of APIs to schedule the ODBC driver. The driver then contacts the DBMS through the SQL statement.
Let's start by introducing ODBC data sources. In the "Control Panel System and Security Management Tool", you can see the ODBC data source icon.
Double-click to open the ODBC Data Source Manager, as shown below:
The ODBC Data Source Manager provides the most succinct way to configure, add, and delete various data source names. It allows users to easily configure the data source, and the user can delete the original DSN (data source name) or modify the previously configured data source. The specific functions of the ODBC Data Source Manager are as follows:
▲ User DSN: The ODBC user data source stores information about how to connect to the specified data provider. The user data source is only visible to the current user and can only be applied to the unit.
▲System DSN: The ODBC system data source stores information about how to connect to a specified data provider. The system data source is visible to all users on the current machine.
▲File DSN: The ODBC file data source allows users to connect to the data provider. The file DSN can be shared by users who have the same driver installed.
▲ Drivers: ODBC drivers allow ODBC-enabled programs to obtain information from ODBC data sources. If you are installing a new driver, use its installer.
▲ Tracking: ODBC tracing allows you to create a log that calls the ODBC driver for the technician to view; it can also assist in debugging the application. Visual Studio tracks the ODBC trace that starts Microsoft Visual Studio.
▲Connection Pool: The connection pool allows the application to reopen the connection handle, which stores the round trip process to the server.
Foreign Michael Crump community users also share this batch installation skills, ordinary users only
Step 1 Open the Control Panel, and then click Add Language: Step 2 In the location shown below, cli
1. Open the “Control Panel” window, set the view mo
1. Enter the control panel and select the language; 2. Click o
How to log in to Win8 system with PIN code
How to enable Bitlocker driver encryption function under Win8 system
How to solve Win8 twice every time you start it?
Microsoft: IE10 is the fastest and smoothest browser on Win8
Windows 8 system IE10 can not install Flash Player plugin
Windows8 upgrade Win8.1 Update convenient Raiders
Win8 will have eight independent versions. Is it still a rumor?
Win8 system logout function tutorial
Win8.1 system SkyDrive settings file offline available method
What should I do if the win8 system is suspended?
Trouble shutdown operation! See win8.1 how to set up easy shutdown
How to customize the background image of the lock screen interface under Win8.1 system
How to solve Win7 Ultimate error 0x000006d18 problem
From June 2nd: RMB 95, upgrade from Win7 to Win8
How to let CentOS automatically install rar and unrar
Windows7 View Wireless Network Password Tutorial
How to do a red cross on the white flag of the Win8 operation center
Cancel the useless features that come with Windows XP
Press the F8 key to enter the safe mode menu meaning full solution