connecting to a MS Access database using Java
843854Dec 11 2002 — edited Feb 11 2003(Please keep any replies very simple/self explanatory - I'm just a student, and have limited experience dealing with computers (mostly fairly simple coding or theoretical aspects of computer science.) This is the first time that I'm working on an application that is not for school (internship), and there is no one at this company who I can ask for help. I'm feeling quite clueless.)
I am having trouble connecting to a database in MS Access using Java.
I once connected to Oracle using Java, and I remember that I had to install TomCat. Do I have to install something similar to connect to MS Access?
At the moment I am just using code that I have found on java tutorials.
I tried adding the database as a datasource as some of the tutorials describe. However, it seems that I am not doing it correctly. (I'm using Windows XP.)
I keep getting the following errors.
problems connecting to jdbcdbc:db1
problems with SQL sent to jdbcdbc:db1: null
C:\magedb>java db1
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
NOT CONNECTED TO THE TO THE DB.
problems with SQL sent to jdbcdbc:db1: null