Win7 64-bit java. SQL. sqlexception: [Microsoft] [ODBC driver manager] No data source name found and default driver problems not specified

Source: Internet
Author: User
Tags driver manager odbc connection
ArticleDirectory
    • ODBC connection of access under win7

The 64-bit operating system does not support the Microsoft ole db provider for jet driver.ProgramAnd earlier Microsoft Access Driver (*. mdb) connections are not supported. Therefore, the link strings in the program cannot work normally. You need to modify the IIS working environment to 32-bit. On the IIS management interface, enable the default 32-bit option in the application pool.

 

ODBC connection of access under win7

Directly in

Control Panel --- Administrative Tools ---- data source (ODBC)

Open the data source configuration and find that only the driver is available.

 

Solution:

C:/Windows/syswow64

In this directory, find:

Odbcad32.exe

Double-click the file to open it.

There are many data source drivers available, and then you can add ODBC data sources connected to access.

 

 

 

when I learned the ACCESS database using ODBC in Java, the following message is displayed: "Java. SQL. sqlexception: [Microsoft] [ODBC driver manager] in the specified DSN, the architecture between the driver and the application does not match, share the process with you.
open ODBC directly on the win7 64 control panel and only MySQL is available. An error occurs when you add access: "[Microsoft] [ODBC driver manager] in the specified DSN, the architecture between the driver and the application does not match. "go online and check whether C:/Windows/syswow64/odbcad32.exe is a 32-bit ODBC, the Access database can be added. Then I compiled it with my 64-bit java. After running it, I still got the error: "The driver in the specified DNS does not match the application architecture." Finally, I realized that 64-bit Java corresponds to 64-bit ODBC, therefore, Microsoft Office 2010 64bit is installed. This time, the 64-bit ODBC in the control panel can finally be used to add an Access database, and Java compilation and running are also normal. At this time, I am not able to use the 32-bit ODBC in the directory (the previous 32-bit office was uninstalled) and the prompt "Microsoft Access Driver (*. mdb ,*. accdb) ODBC driver installation routine, please reinstall the driver ". According to my analysis, if 32-bit Java is installed, it is also possible to use 32-bit odbc in the system directory, so the software architecture should correspond.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

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.