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 ODBC DSN Programmically 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 "ODBC DSN Programmically" Watch "ODBC DSN Programmically" New topic

ODBC DSN Programmically

Stephen Batsas
Ranch Hand

Joined: Jan 22, 2002
Posts: 117
Can anyone please help me?
I need to create a ODBC DataSource from within Java/JDBC App. I have searched this forum but all I could find are vague suggestions.
Mr. C Lamont Gilbert
Ranch Hand

Joined: Oct 05, 2001
Posts: 1170

You may find a technique to create a DSN, but you will NOT be able to create the file it needs to point too.
Technically you can do this by creating an external script that calls a DLL in the windows system directory. and executing that script to create the mdb file when you wish.
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
Create an ODBC connection to what? A brand new DB? If so that would require creating an Access database or something else with an ODBC driver.
If an existing DB - you can have your program edit the c:/windows/odbc.ini file to put what you need there.
I am wondering why you'd need this. As part of installation?
I agree. Here's the link:
subject: ODBC DSN Programmically
It's not a secret anymore!