jQuery in Action, 2nd edition*
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 Java 8 in Action this week in the Java 8 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: 36579
    
  16
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java and ms access 2007 error "Data source name not found and no default driver specified "
 
Similar Threads
Connecting to a remote mysql database
please I urgently need help
Creating JAR
JDBC/ODBC DRIVER
JDBC with MS Access