Connecting to MS Access 2000

[Josh Forrest]

how do i connect to MS Access 2000. my database name is Josh.mdb.
thanks for any help.

[Sam Moran]

I have a User DSN entry set up first. You can always use a System DSN instead. Your DSN entry would be Josh:

 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String url = "jdbc :-o	 dbc:Josh";
    Connection con = DriverManager.getConnection(url);

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

[Josh Forrest]

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]

Hi,
How can make DSNless connection to ms access databas.
Thanx
kholu

[Gregg Bolinger]

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

[Thomas Paul]

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

[Jamie Robertson]

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:

/* DSN connection
String url = "jdbc:odbc:emp";
//DSNNAME is the datasource name you created in the control panel
Connection sconn = DriverManager.getConnection( url, "userID", "passwd");
*/

/* DSN-less connection */
//connection is (lightly) tested for Microsoft Access 97 driver 4.0 and up
//to check your driver version:
//click Start->
//Settings->
//Control Panel->
//ODBC Data Sources (32bit)->
//Drivers tab->
//Should display Microsoft Access Driver(*.mdb) - version x.xx.xxxx.xx
//for this connection, the database named 'emp' should be located at: C:\temp\data\emp.mdb
Connection sconn = DriverManager.getConnection("jdbc :o dbc :D river={MicroSoft Access Driver (*.mdb)};DBQ=C:\\temp\\data\\emp2.mdb","Admin","");

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]

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]

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.