Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc-odbc question?

 
Tom Barns
Ranch Hand
Posts: 138
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Manjunath Reddy
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...
cheers,
mpr
 
David Weitzman
Ranch Hand
Posts: 1365
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic