File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to create a dsn through java program" Watch "how to create a dsn through java program" New topic
Author

how to create a dsn through java program

salamath ahamed
Greenhorn

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


salamath
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

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: http://aspose.com/file-tools
 
subject: how to create a dsn through java program