• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

jdbc-odbc question?

 
Ranch Hand
Posts: 138
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1365
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: "jdbc:odbc: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 'jdbc:odbc' had a smily face in the middle.
[This message has been edited by David Garland (edited August 23, 2001).]
 
Sunglasses. AKA Coolness prosthetic. This tiny ad doesn't need shades:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic