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
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
64-bit Machine ODBC operation method and 32-bit machine is not the same, if directly from the Control Panel-Administrator tool-ODBC into the user DSN and the System DSN is empty, add when even ODBC driver can not be found, the correct method should
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
The workaround for "the architecture mismatch between the driver and the application in the specified DSN" is an exception when connecting programs and databases via ODBC/JDBCNative : 64-bit win7,64-bit JDK, 32-bit myeclipse for web experiments
First, prefaceWe may encounter this need at work: Query the information in the database and export the results to an Excel file. This would have been nothing, but when the amount of data is large, using Plsql, Toad Export Excel will be out of memory,
Environment:
Operating system: 64-bit WIN7 database: SQL Server SP1 Development language: Java EE
Error prompting when Servlet connects to database:
[Microsoft] [ODBC Driver Manager] in the specified DSN,
First find The DSN location
Chinese version: Control Panel-> Administrative Tools-> data source (ODBC)
English version: control pannel-> Administrative Tools-> data source (ODBC)
Click Add on userdsn, find MySQL ODBC driver, and fill in the
This problem occurs when you use ASP to connect to the MySQL database.One afternoon, it was an ODBC data source problem.Record it:Cause of error: The 64-bit system uses 32-bit ODBC.Workaround: Use 64-bit ODBC for no problem.32-bit ODBC in the
1. Relationship between ODBC, oledb, ADO, and ADOX:ODBC: a standard for Database CommunicationOledb: Ms intends to use it to replace ODBC in an object-oriented manner.Oledb is divided into two types: Direct oledb and ODBC-oriented oledb. The latter
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.