This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes how to connect to my MS Access DB through JDBC but not ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to connect to my MS Access DB through JDBC but not ODBC" Watch "how to connect to my MS Access DB through JDBC but not ODBC" New topic
Author

how to connect to my MS Access DB through JDBC but not ODBC

adachi
Greenhorn

Joined: Jun 26, 2001
Posts: 9
Hi,
I am developing a software that want to connect to a ***.mdb when I distributed it. So, I can't set anything in the client's computer such as ODBC. Thus, I want to use JDBC connect to the Database directly.
Can I?
Thanks for you attention
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Does this thread cover what you are looking for?
Dave
[This message has been edited by David O'Meara (edited November 25, 2001).]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"adachi",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in again with a new name which meets the requirements.
Thanks.
Dave
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

I think you are looking for a DSN-less connection to access:

this will connect to the emp database located at C:\Temp\data
Jamie
note, this still uses the jdbcdbc bridge so you can only connect to a local database (I haven't tested it).

[This message has been edited by Jamie Robertson (edited November 26, 2001).]
[This message has been edited by Jamie Robertson (edited November 26, 2001).]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to connect to my MS Access DB through JDBC but not ODBC