aspose file tools*
The moose likes JDBC and the fly likes Automatically registering ODBC Database in Windows Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Automatically registering ODBC Database in Windows" Watch "Automatically registering ODBC Database in Windows" New topic
Author

Automatically registering ODBC Database in Windows

Ricardo Marques
Greenhorn

Joined: May 08, 2002
Posts: 27
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


Sun Certified Programmer for the Java 2 Platform 1.4<p>If I can create, I will make mistakes. If I can learn with them, it must be some kind of art.
Blake Minghelli
Ranch Hand

Joined: Sep 13, 2002
Posts: 331
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?


Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
Ricardo Marques
Greenhorn

Joined: May 08, 2002
Posts: 27
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.
 
 
subject: Automatically registering ODBC Database in Windows