How to add an access driver to an ODBC data source in win7

ArticleDirectory

•  

Sometimes in W7, ODBC data source driverProgramOnly SQL

Many people have encountered similar problems.

In some versions, you can [access "Administrative Tools" from the "control panel" and then access "Data Source (ODBC)"] as follows: CMD enter % WinDir % \ syswow64 [There are 32-bit programs in it! A lot!] You can also manually enter and run odbcad32.exe, And the settings are the same as those of XP! It is estimated that you are a 64-bit system program. If you cannot find it, you can write get jet odbc driver for windows7 in Google. There will be a lot of answers!

Try it.

In addition, accessCode:

// 1. Load the driver,
Class. forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
// 2. Establish a connection and specify the URL containing the name registered by the database in the data source
String url = "JDBC: ODBC: Score ";
Conn = drivermanager. getconnection (URL );
// 3. Obtain the object for executing the SQL statement from the connection
Stmt = conn. createstatement ();
Score is the database name.