This article describes the simple principle of ODBC and how to install, configure, and program ODBC in Linux/Unix.
ODBC principles
ODBC is the abbreviation of open database connect, which is a unified interface standard proposed by
(DSN) Data Source NameThe ODBC Data Source Administrator provides three types of DSNs, User DSN, System DSN, and File DSN, respectively.whichThe user DSN saves the appropriate configuration information in the Windows registry, but only the logged-on
This page contains more information about setting up and using the ODBC Connector hive. This page contains the following topics: Before you start the SQL Connector software and hardware requirements to install and configure authentication in DSN
To create a data source nameTo connect to a database by using ASP pages, you must first create a data source name (DSN) on the WEB server for the type of database that you want to connect to. To do this, use one of the following methods.To create a
Objective:The main explanation of ODBC API, take MySQL as an example, from configuration to installation, and then to specific programming, with a view to ODBC have a preliminary understanding.*) Download MySQL, select Community Edition MySQL, and
*) Basic concept:1. Application (Application)2. ODBC Driver Manager (ODBC Driver manager)Responsible for managing communication between applications and drivers, including parsing DSNs (data source names, ODBC data source names configured in the
Configure ODBC connection (oracle) and webspherebroker for websphere message broker
1. Windows environment Configuration
Steps:
1. Click Start> Control Panel> Management Tools> data source (ODBC)
2. Click the system DSN tab and click Add
3.
The Open Database Connection (ODBC) interface is defined by Microsoft Corporation and is a standard interface used in Windows to connect client applications to the database management system. You can specify the connection parameters to connect.
The Open Database Connection (ODBC) interface is defined by Microsoft Corporation and is a standard interface used in Windows to connect client applications to the database management system. You can specify the connection parameters to connect.
1. Windows Environment ConfigurationSteps:1. Click Start > Control Panel > Administrative Tools > Data source (ODBC)2. Click the System DSN tab and click Add3. Configure new DSN4. Turn off ODBC Configuration, modify registry Click Start > run input
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.