File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes dsn less connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "dsn less connection" Watch "dsn less connection" New topic

dsn less connection

Jithesh Kozhipurath
Ranch Hand

Joined: Aug 27, 2003
Posts: 76
Hai friends,
I did one java application that uses JDBC MS access database. For each installation in a new system a dsn is to be created, is there any method to avoid this, Or any connection method without DSN. Is there any free drivers available for a dsn less connection.
Thanks in advance....

Jithesh K
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
Sun maintains a web page where you can search for JDBC drivers: click here. You want to search for vendors who support MS Access with a type 4 (or possibly type 3) driver.
I'm not aware of any "free" versions, but the sun site is a great place to start looking.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

have a look at my post here. Not something I would trust in a production environment, but it works fine for testing.
Jithesh Kozhipurath
Ranch Hand

Joined: Aug 27, 2003
Posts: 76
Thank you friends...
I agree. Here's the link:
subject: dsn less connection
It's not a secret anymore!