developerWorks: ODBC Programming Using Apache Derby

"Open Database Connectivity (ODBC) is one of the most popular ways today to code a database application. Let's begin our examination of ODBC programming for Apache Derby by comparing ODBC applications with embedded SQL applications.

"Embedded SQL applications contain SQL statements embedded into the source code, which is written using a high-level language, a common example being C. ODBC applications, in contrast, use a standard set of APIs to communicate with the database. The SQL statements are sent using these standard API methods to the database manager for processing..."

Complete Story

Related Stories:

• LinuxWorld: Making MySQL, ODBC & OpenOffice 1.0 Work Together, Part 2(Feb 19, 2003)
• unixODBC.org: OpenOffice.org 1.0, unixODBC, and MySQL(Jun 13, 2002)
• IBM developerWorks: Integrating database access into Linux applications; Building a MySQL-backed Web site(Feb 26, 2001)