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 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "odbc" Watch "odbc" New topic


kelly devon
Ranch Hand

Joined: Apr 15, 2004
Posts: 77
could anyone help me with the steps to configuring the odbc data source management to use access with java before writting the sql?
thx in advance

Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
Hi Kelly,

My first recommendation is to say don't use ODBC with Java. Get yourself a JDBC driver for the type of database you're using. They're typically available free from the website of the vendor or they're shipped with the DB installation.

If you're just playing then you can set up an ODBC connection by running odbcad32.exe in Windows. This launches a wizard. Set up a System DSN by clicking Add on the System DSN tab and following the instructions. The instructions are typically different for each different type of database.

Hope that helps.

I agree. Here's the link:
subject: odbc
It's not a secret anymore!