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!