File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes java and ms access 2007 error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java and ms access 2007 error "Data source name not found and no default driver specified "" Watch "java and ms access 2007 error "Data source name not found and no default driver specified "" New topic
Author

java and ms access 2007 error "Data source name not found and no default driver specified "

randall erasmus
Greenhorn

Joined: Apr 19, 2011
Posts: 2
Hi Java Gurus

Im really struggling to sort out this problem can you help me out. I have been struggling for a few days now
with this problem.

I will paste my code here :

Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39478
    
  28
Welcome to the Ranch

I have added code tags, and broken some of the long lines; you can see how much better your code looks Beware on this forum: tick the disable smilies box otherwise :‍odbc turns into dbc.
But you haven’t told us what goes wrong; we can’t help if we don’t know. Do you suffer an Exception? If so, please show us the stack trace. Do you need a password?
Saif Asif
Ranch Hand

Joined: Aug 11, 2011
Posts: 440

Morning Randall and welcome to the Ranch.

I think you have the driver name wrong. As far as I remember the Driver name is jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};; . Try this



Muhammad Saif Asif Mirza
OCJA(5/6) OCJP(6) OCJWCD(6)
Carles Gasques
Ranch Hand

Joined: Apr 19, 2013
Posts: 199
    
    1
Hi,

Java Ranch has a reference in this topic JDBC ODBC FAQ .


I have accomplished this task always using an odbc datasource configured in windows (control panel / Administrative tools / Data Sources), say myds, and then


Best regards,
randall erasmus
Greenhorn

Joined: Apr 19, 2011
Posts: 2
Hi Java Gurus

thanks alot to Saif Asif Mirza your input helped me fixed the problem. Oh and sorry for only replying now.


regards, Randall Erasmus
 
 
subject: java and ms access 2007 error "Data source name not found and no default driver specified "