Access database connect trouble

[Solja]

Connecting to a .mdb database which has been placed inside the project folder. The project runs fine on the school computers (Netbeans 6.5 - WinXP (x86))

As soon as I bring the project home to work on it wont connect to the database. Using the exact same project. (Using Netbeans 6.8 - Win7 (x64))

Here is the error I get:

run:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at term2project.Personality.connectToDB(Personality.java:365)
at term2project.Personality.<init>(Personality.java:20)
at term2project.Personality.main(Personality.java:387)
java.lang.NullPointerException
at term2project.Personality.closeDBCon(Personality.java:377)
at term2project.Personality.<init>(Personality.java:30)
at term2project.Personality.main(Personality.java:387)
BUILD SUCCESSFUL (total time: 1 second)




I think it may have something to do with the odbc driver not being installed for 64-bit?

Any help will be greatly appreciated

[ChakrabortyAnshu]

Please check if the DSN you are trying to use for connectivity purpose is properly configured?

You can check this in Control Panel >Administrative Tools > Data Source.