This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Type 4 JDBC Driver for MS_Access

 
prantik bordoloi
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 89
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 243
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you sure they are for free?
 
Jeff Hancock
Greenhorn
Posts: 11
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From what i have read, JDBC DBC bridge to Access can only be accomplished with a type 1 driver.
 
Jeff Hancock
Greenhorn
Posts: 11
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 16
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 89
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Windows 95, Java 1.3, MS Access 97 example connection method. Note: Not Type IV driver but it works.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic