(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
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
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]
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
Method 1: Using the CreateTableDef method
CreateTableDef method to create a linked table. To use this method, create a new module, and then add the following attachdsnlesstable function to the new module.
Copy Code code as follows:
Is the connection database still connected to the database using an ODBC system or file DSN? Replace it with an OLE DB provider, which is faster and does not require the use of DSN
According to the Library connection technology. With OLE DB
This paper presents a method of directly connecting a server-side DSN without having to define a DSN file on the client.Of course, this is not a mainstream approach, just to open up ideas, more useful scenes can be used in the Ttisql utility, used
Pdo is a newly added database abstraction layer in php5. to solve the problem of accessing the unified interfaces of different databases. Similar to PEAR: DB Class and ADODB class operations, but it is directly encapsulated in php extension and can
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.