JDBC ODBC SQLException

[JohnPringle83]

Hello I am trying to connect to a data source with the ODBC Data Source Administrator but I am getting an error when I run.

The error that I am getting is:

SQL Error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application 0 IM014

The code is:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class CoalReporter {
	public static void main(String[] args){
		String data = "jdbc:odbc:WorldEnergy";
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn = DriverManager.getConnection(
					data,"","");
			Statement st = conn.createStatement();
			ResultSet rec = st.executeQuery(
					"SELECT * "+
					"FROM Coal "+
					"WHERE "+
					"(Country='"+args[0]+"') "+
					"ORDER BY Year");
			System.out.println("FIPS\tCOUNTRY\t\tYEAR\t"+
					"ANTHRACITE PRODUCTION");
			while(rec.next()){
				System.out.println(rec.getString(1)+"\t"
						+rec.getString(2)+"\t"
						+rec.getString(3)+"\t"
						+rec.getString(4));
			}
			st.close();
		}catch(SQLException s){
			System.out.println("SQL Error: "+s.toString()+" "
					+s.getErrorCode()+" "+s.getSQLState());
		}catch(Exception e){
			System.out.println("Error: "+e.toString()
					+e.getMessage());
		}
	}
}

I have used the odbcad.32 in this location: c:\windows\sysWOW64\odbcad32.exe as advised by this website: Managing Data Sources but I still get the error.

[mine0926]

what database are you trying to connect?

[JohnPringle83]

I'm trying to connect to a MS access DB

[mine0926]

Check step 1 to 4. Have you done this steps?
Accessing Ms Access Using Java


You could also try to change your string data to something like this,

String databasePath = "D:\\myDatabase.mdb";
String data = "jdbc:Odbc:Driver={Microsoft Access Driver (*.mdb)};"
        + "DBQ=" + databasePath;

I am not familiar using MSAccess in java so this might NOT be the CORRECT WAY to connect it.

[JohnPringle83]

I checked that I had followed those steps and I have, I also tried the code you gave me, but I am still getting the same error. I am using 64 bit machine if that is any use to you.

[masijade]

Uhm, you have a "64 bit system", but do you have a "64 bit Office" or is your office suite 32 bit. According to the error (and the page you provided) it looks as though your office system is 32 bit and therefore you are using the 64 bit odbcad32.exe to configure a 32 bit driver and there fore are getting an error when using that configuration.

[JohnPringle83]

I did have 32 bit office 2007 installed but now I have got 64 bit office 2010 installed and everything is working just how it is meant to be.

Thanks for your help, I'd have never figured that one out on my own.