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.
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
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com