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 Programmicly setup DSN 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 "Programmicly setup DSN" Watch "Programmicly setup DSN" New topic

Programmicly setup DSN

Dean Reedy
Ranch Hand

Joined: Sep 10, 2001
Posts: 89
I wondering is there any way to programmicly setup a DSN(OBDC) to a MS Access database. Basicly I want the users to be able to push a button and setup a DSN for there local MS Access database.
Any ideas?
Paul Misoni

Joined: Jan 02, 2001
Posts: 16
The short answer is "yes", but it depends upon how you prefer to go about it. If you like doing things the old-fashioned way, you should be able to do it using batch files. This is a pretty good way if all the users are configured the same.
If you need to do it for any of several different Windows OSs, you might want to consider something like InstallShield Express (I'm not trying to push their software(it's not exactly cheap...around $600 with support, last time I checked), but could save you a lot of time and effort.
...and you can try it for free.
I haven't checked out the stuff from WISE, but they probably have something comprable.

I'm sure that others may have some additional solutions as well.
I agree. Here's the link:
subject: Programmicly setup DSN
It's not a secret anymore!