gdkinney_2
asked on
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
Thank You,
Dave
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
guidway
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.
>> 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.
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.