Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Automatically registering ODBC Database in Windows

 
Ricardo Marques
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everybody.
I am developing an application in Java which needs to access a Database via JDBC/ODBC in Windows (it will always run in Windows, that is one of the client's pre-requisites...).
Assuming that my client has already installed Office (with Access) ODBC will be available. What I need to know is out to set up a database as an ODBC service.
I don't want to do it manually (Control Panel, ODBC, ...), but instead I wish to do it in somekind of script-like manner so that it can be done at install time, when my application is installed.
I don't think that this forum is the most appropriate, but it is certainly worth trying.
Any help would be most appreciated.
Ricardo Marques
 
Blake Minghelli
Ranch Hand
Posts: 331
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You'll want to avoid using the ODBC bridge driver unless you have to. What kind of database is your app connecting to (e.g. mssql, mysql, oracle, etc)? Does the db vendor offer a jdbc driver for it?
 
Ricardo Marques
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The database is ACCESS. It has to be. It's a prerequisite.
How do I connect to an ACCESS Database if it is not via JDBC-ODBC bridge? Thanks you.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic