Win a copy of Beginning Java 17 Fundamentals: Object-Oriented Programming in Java 17 this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

Type 4 JDBC Driver for MS_Access

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Are you sure they are for free?
 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Windows 95, Java 1.3, MS Access 97 example connection method. Note: Not Type IV driver but it works.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic