This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Programmicly setup DSN Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Programmicly setup DSN" Watch "Programmicly setup DSN" New topic
Author

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
Greenhorn

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: http://aspose.com/file-tools
 
subject: Programmicly setup DSN