ODBC Driver problem with Java Programming?

Question

Right so ive been writing this program in Java for some time now, and its been working fine. What it does is connect to a microsoft access database, and extracts and writes data to it (as well as some other stuff which isnt really important to this question). Iv'e recently upgraded to windows 7 64 bit OS, and now im getting this error when it tries to connect to the DB:

Data source name not found and no default driver specified

I know the code is right, because I had it working on my old windows xp computer, and my Vista.
Iv'e had a look at some examples on the internet about how to set up your own DSN, but theyre all for SQL servers which is of no use to me. Ive tried to set up my own DSN, but it dosent seem to work...

Can any one provide me with step by step instructions to set up my own DSN for an access database (.mdb) and select the default driver.

Thanks for any help you may be able to provide me with :)

Answer 1

ODBC is a royal pain in the butt. Since you're using Java, why don't you switch to the JDBC database driver instead? If you designed your program properly it just means writing a new database adapter object and swapping it out on your data access object.

Answer 2

choose Userdsn tab, click add , choose MicrosoftAccessDriver(*mdb), give the dsn and choose ur Database where it is located,



It may useful to u....

Answer 3

first get oracle drivers on your java its an lib you could characteristic ie. your using oracle ninety one skill discover the class12.jar record on your oracle put in folder replica it and upload it contained in the lib of your java folder in any different case use java IDE like jcreator or Eclipse . i element your application isn't ultimate use stack hint for extra effective view in any different case first write the relationship area in simple terms verify its working positive then proceed extra else verify this hyperlink for reference ..