Type 4 JDBC Driver for MS_Access

[prantik bordoloi]

Can anybody tell me where i can find a JDBC1.0 compliant type4 driver for MS-Access. And Please i want a free driver.

[Ming_chen]

I don't know what is type 4 JDBC, but as I know using JDBC to connect MS_Access is very easy and simple.
Step 1: create or select a DSN for MS_Access Driver (through ODBC Data Source Administrator).
Step 2: make connection in you java program, set String url = "jdbc dbc:yourDSN";
Step 3: in the try block, call Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); then you got the driver
Step 4: in Connection try block: Connection conn = DriverManager.getConnection(url, userName, passWord); you can set userName and passWord to empty string " ", because Access does not require these.
Step 5: create your Statement stmt = conn.createStatement().. then you're on the way.

[Kareem Gad]

Prantik ,
http://industry.java.sun.com/products/jdbc/drivers/search-results/1,2722,,00.html
check out this site and you'll find a list of JDBC driver vendors. they are for free.


------------------
KaReEm

[Stanley Tan]

Are you sure they are for free?

[Jeff Hancock]

From what i have read, JDBC DBC bridge to Access can only be accomplished with a type 1 driver.

[Jeff Hancock]

And even that does not work. Even with ODBC connections to the database setup (SYSTEM, USER and FILE), all fail with Data Source not found and no default driver specified.
I don't believe there is a way to connect to MS Access from Java.

[Gregg Bolinger]

Originally posted by Jeff Hancock:
And even that does not work. Even with ODBC connections to the database setup (SYSTEM, USER and FILE), all fail with Data Source not found and no default driver specified.
I don't believe there is a way to connect to MS Access from Java.

You're crazy. It can be done.

[Paul Misoni]

Jeff,
You should pay attention to Gregg's tag line.
Ignorance can usually be cured. That's one reason that we have forums.
If you search the history for the JDBC forum you may find one or two entries that indicate that you actually can connect to MS Access from Java.

Please excuse the sarcastic overtones of my post...I can't seem to contain myself.

[David O'Meara]

Originally posted by Paul Misoni:
Please excuse the sarcastic overtones of my post...I can't seem to contain myself.

Yep, you're a bad person.
Lucky there's room for two of us.

[Richa Pandharikar]

As far I know I think there is no type 4 driver for Ms Access. Am I correct ?
I too am looking for it.
Any help will be appreciated ...
Thanks
Cheers !
Richa

[Larry UpNorth]

I am running on Windows-95 with JDK 1.3 connecting to an Access-97 db with no problems.
Just follow the steps listed in the response by Ming Chen. I did not need to install any special driver.
Hope this helps.

[Dean Reedy]

Windows 95, Java 1.3, MS Access 97 example connection method. Note: Not Type IV driver but it works.

 public static Connection getConnection()
throws SQLException, InstantiationException,
IllegalAccessException, ClassNotFoundException {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
return DriverManager.getConnection("jdbc :-o	 dbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=DatabaseName.mdb;PWD=mypass""login", "password");
}