Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link

Ming_chen

Greenhorn
+ Follow
since Aug 14, 2001
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Ming_chen

Your data source name is "Book.mdb", but you use "jdbc dbc:Books" in your DriverManager.getConnection(), remove "s" of "Books", it should work, otherwise you should check if your data source is created correctly.
[This message has been edited by Ming_chen (edited August 22, 2001).]
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.