File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes jdbc-odbc question? 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 » Java » Java in General
Bookmark "jdbc-odbc question?" Watch "jdbc-odbc question?" New topic

jdbc-odbc question?

Tom Barns
Ranch Hand

Joined: Oct 27, 2000
Posts: 138
Hi all
I know very well how to coomunicate with database using jdbc api.
what i need to understand more is what is odbc?please if you can explain to me in details what it is or at least a site that i can read about it.
Thanks a lot for your time.

Thanks for your help.
Manjunath Reddy
Ranch Hand

Joined: Jul 26, 2001
Posts: 60
Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language.
Primarily implemented by Microsoft, java came up with drivers to interface with ODBC through its JDBC-ODBC bridge. Though i wont say its faster than pure java drivers, it serves as a bridge for data access with say microsoft access, excel sheets...etc.. through a DSN created in ODBC configuration.
Hope this gets u going...
David Weitzman
Ranch Hand

Joined: Jul 27, 2001
Posts: 1365
Warning: I only have windows 98 available. There may be some differences between versions.
Example: Create an MS Access Database. Go to Control Panel -> ODBC Data Sources. Move to tab System DSN. Click 'Add'. Choose 'Microsoft Access Driver' (unless you like spanish drivers...). Data Source Name = the 'name' in this Jdbc url: "jdbcdbc:name". Description is useless. Click select and choose the database you created. Click OK. Wala. Load the odbc driver and use the aforementioned URL to run some jdbc. Hope this was useful.
Geez, the first time I posted this 'jdbcdbc' had a smily face in the middle.
[This message has been edited by David Garland (edited August 23, 2001).]
I agree. Here's the link:
subject: jdbc-odbc question?
jQuery in Action, 3rd edition