Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

Using Java and JDBC with Microsoft Access

I want to use Java and JDBC with a Microsoft Access database.  Do I have to use the JDBC-ODBC bridge?  Is there a faster JDBC bridge for Access?  Is it free or does it cost?  Also must I create an ODBC datasource in Control Panel to make the Java-Access connection?  If I do is there a way to create the ODBC datasource through Java code inside a Java applicaton so that users do not have to create the ODBC datasource themselves?

Thank You,
Dave
0
gdkinney_2
Asked:
gdkinney_2
  • 2
1 Solution
 
guidwayCommented:
>>Also must I create an ODBC datasource in Control Panel to make the Java-Access connection?<<
>> If I do is there a way to create the ODBC datasource through Java code inside a Java applicaton so that users do not have to create the ODBC datasource themselves?<<

You can do this programmatically:
http://www.rgagnon.com/javadetails/java-0345.html

I am not very current on Java lately so your other questions will be better addressed by another expert.
0
 
guidwayCommented:
p.s. This is called a DSN-less connection. Everything is done through code, nothing has to be created in the ODBC data source control panel applet.
0
 
riaancorneliusCommented:
>> I want to use Java and JDBC with a Microsoft Access database.  Do I have to use the JDBC-ODBC bridge?
Not necessarily, there is some JDBC drivers out there, but they are very expensive. look at:
http://www.aveconnect.com/jdbc-driver-MS-Access.htm

>> Is there a faster JDBC bridge for Access?
Yes, look at previous point. You really pay for this increased performance though...

>> Is it free or does it cost?
It definately costs. You can look at the abovementioned website for the price on that specific one, or search google (java JDBC MS access driver).

>> Also must I create an ODBC datasource in Control Panel to make the Java-Access connection?  
Not necessarily. See next point.

>>If I do is there a way to create the ODBC datasource through Java code inside a Java applicaton so that users do not have to create the ODBC datasource themselves?
I connect to access using pretty much the method guidway points to in his post. I've never had a problem with that. The only problem is that you need to know where the actual db file is, but if you create it, this isn't a problem.

If you need any other info, feel free to ask.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now