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 Connecting to MS Access 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to MS Access 2000" Watch "Connecting to MS Access 2000" New topic
Author

Connecting to MS Access 2000

Josh Forrest
Greenhorn

Joined: Oct 08, 2002
Posts: 7
how do i connect to MS Access 2000. my database name is Josh.mdb.
thanks for any help.
Sam Moran
Ranch Hand

Joined: Sep 28, 2002
Posts: 86
I have a User DSN entry set up first. You can always use a System DSN instead. Your DSN entry would be Josh:

I hope this is what you are looking for? If not, please supply a little more detail.


We make a living by what we get, we make a life by what we give!
Josh Forrest
Greenhorn

Joined: Oct 08, 2002
Posts: 7
would i place the directory path in the url string? for example...
String url = "jdbc.odbc:josh\AccessDB\Josh.mdb";
conn = DriverManager.getConnection(url);
thanks for you help!
Khaled Elmassry
Greenhorn

Joined: Jan 23, 2003
Posts: 1
Hi,
How can make DSNless connection to ms access databas.
Thanx
kholu
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

I don't think you can. I don't believe anyone has written a driver to do that.


GenRocket - Experts at Building Test Data
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
You don't have to use the ODBC driver. There are other drivers available. Check the link below.
http://industry.java.sun.com/products/jdbc/drivers


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

you can bypass the DSN by giving an ODBC compatible URL. This is what I use to connect to my Access database without using a DSN:

The DSN-less connection assumes that
1. you have the specified access driver already installed on your computer.
2. the driver specified in 1 can successfully communicate with the database specified in the URL
3. The database exists in the location specified in the URL and has the same name.
4. You didn't add remove any spaces from the connection URL. If you did, re-cut and paste my code because the URL is space sensitive.
5. All the planets are aligned correctly
I have seen guys pull their hair out trying to get this one going, that's why I mention assumption 5. This is not an elegant solution that is portable. Just because it works for me or you, doesn't mean that it will work for a friend( too many OS and Access driver version variations ).
Jamie
[ January 23, 2003: Message edited by: Jamie Robertson ]
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
If I remember correctly, Sun does not recommend that the JDBC-ODBC bridge be used for production.
Found the link:
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html
The JDBC-ODBC Bridge driver is recommended only for experimental use or when no other alternative is available.
[ January 23, 2003: Message edited by: Thomas Paul ]
Sam Moran
Ranch Hand

Joined: Sep 28, 2002
Posts: 86
The single most reliable way is to use the DSN entry! It works! Simple and easy! This way you do not have to worry about the Planets! I've been there before. It takes 1 minute tops to create a DSN entry.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to MS Access 2000