This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

ODBC DSN Programmically

 
Stephen Batsas
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
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.
Regards
Stephen
SCPJ
SCWCD
 
Mr. C Lamont Gilbert
Ranch Hand
Posts: 1170
Eclipse IDE Hibernate Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 227
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!