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

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.