hello everyone. I'm trying to connect to an access database. When I was working on this at the computer lab at my school, the connection worked just fine. when i got home, i get this error:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I googled this and found it has something to do with my computers DSN but i'm not sure how to fix it. i tried various suggestions but nothing is working. when i go to ODBC Data Source Administrator (in control panel) I go to the System DSN tab and click Add but there are no Access *mdb, *accb choices available (only SQL Native Client, SQL Server, and SQL Server Native Client 10.0).
I'm running Windows 7 Home Premium 64 bit OS.
Thanks for your help