• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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