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 how to create a dsn through java program Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to create a dsn through java program" Watch "how to create a dsn through java program" New topic

how to create a dsn through java program

salamath ahamed

Joined: Aug 11, 2003
Posts: 7
hi all javaites
i need a little help on program , i have developed a java desktop application with access database.i did evertyhing fine and the program is working, but my concern is that i have go to control panel to create a dsn manually , is it possible to create a dsn from inside the java program itself , so that any one who uses the program need not go and create dsn for this application. if any one knows the solution please reply
thank you buddies

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

Creating a DSN entry is a Windows Specific function. You can't manipulate the ODBC settings from within a pure java applicaiton. Windows does have some pretty darn good documentation on the ODBC SDK so if you wanted to try your hand at some JNI to call native windows functions from JAVA, more power to you. I woulldn't want to do it.
Just out of curiosity...Why are you using the ODBC bridge to connect to your database? You should be using a Type IV Driver and screw the ODBC. ODBC is bulky and slow.

GenRocket - Experts at Building Test Data
I agree. Here's the link:
subject: how to create a dsn through java program
It's not a secret anymore!