ODBC (Open Database Connectivity)
DSN (data source name)
The ODBC Data Source manager provides three DSN types: User DSN, system DSN, and file DSN.
1. the user DSN will save the corresponding configuration information in the Windows registry, but
ODBC (Open Database Connectivity, ODBC) means open database InterconnectionDSN (data source name) is the data source name
ODBC contains user DSN, system DSN, and file DSN.Three data sources.
The meaning of user DSN is to save the corresponding
10.9 automatically register DSN and Create Table
When writing your own database applications, readers will soon encounter two headaches. First, you must manually register the DSN (Data Source Name) in the ODBC manager before accessing the ODBC data
Access | data | database
Program Database Classes
ActiveX Data Objects (ADO) is an easy-to-use and extensible technique for adding database access to a Web page. You can use ADO to write compact and concise scripts to connect to Open database
(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
PDO ConstructorIn PDO, to establish a connection to a database requires a constructor that instantiates the PDO, the PDO constructor has the following syntax: __construct (String $dsn [, String $username [, String $password [, array $ Driver_options]
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
The following is a brief introduction to several ADO connection methods: ODBC dsn,odbc dsn-less, OLE DB Provider, and "MS Remote" Provider.I.dsnoConn.Open "Dsn=advworks; Uid=admin; pwd=; "Note: It is not possible to use this method from the
You can obtain the DSN list in C #, or pop up the ODBC data source Manager to set it.
1. C # obtain the DSN list on the machine.
Use registrykey and Registry provided by Microsoft. Win32 to access the system registry to obtain the list of ODBC data
Access | data | Database A DSN connection requires the server's system administrator to set up a DSN with the ODBC tool in Control Panel on the server, or use a Third-party server component to have your ASP script create DSN by modifying the
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.