What is ODBC?

ODBC is the acronym for Open DataBase Connectivity, a Microsoft Universal Data Access standard that started life as the Windows implementation of the X/Open SQL Call Level Interface specification. Since its inception in 1992 it has rapidly become the industry standard interface for developing database independent applications. Is is also the emerging standard interface for SQL based database engines replacing many of the first generation Embedded SQL and proprietary call level interfaces provided by database engine and database connectivity middleware vendors alike.
What is the ODBC Value Proposition?

The ability to develop applications independent of back-end database engine.
What is iODBC?

iODBC is the acronym for Independent Open DataBase Connectivity, an Open Source platform independent implementation of both the ODBC and X/Open specifications. It is rapidly emerging as the industry standard for developing solutions that are language, platform and database independent.

What is the iODBC Value Proposition?

The ability to develop applications independent of back-end database engine, operating system, and for the most part programming language. Although ODBC and iODBC are both 'C' based Application Programming Interfaces (APIs) there are numerous cross language hooks and bridges from languages such as: C++, Java, Perl, Python, TCL etc.

iODBC has been ported to numerous platforms, including Linux (x86, Itanium, Alpha, Mips, and StrongArm), Solaris (Sparc & x86), AIX, HP-UX (PA-RISC & Itanium), Digital UNIX, Dynix, Generic UNIX 5.4, FreeBSD, MacOS 9, MacOS X, DG-UX, and OpenVMS and now on AmigaOS4.

Which drivers are supported?

Actually most of common Open Source database are supported. Drivers for MySQL, PostgreSQL and SQLite are present into the package and has been tested connecting AmigaOS4 to a Windows machine. Also SQL Server is supported. Other drivers are in working. Check the Driver page for all news about driver pages.

Supported Drivers

• SQL Server - Driver for Microsoft SQL Server / SyBase Database (0.83)
  
• MySQL - Driver for MySQL Server Database (3.51.27r695)
  
• PostgreSQL - Driver for PostgreSQL Database (06.40.0007)
  
• SQLite3 - Driver for SQLite3 Database (0.83)
  
• MS Access - Driver for Microsoft Access Database
  
• NN - Driver for News Server access
  

Main Features of the ODBC Engine

• Fully localized (only English available at moment)
  
• Package installer
  
• Connection Wizard
  
• Inline hint infos
  

Main Features of the SQL Manager

• Fully localized (only English available at moment)
  
• Package installer
  
• XML export
  
• Undo/Redo functions on Texteditor based to the reaction class
  
• Cut/Copy/Paste functions on Texteditor based to the reaction class
  
• Load/Save/Save As functions
  
• Possibility to stop a query
  
• Possibility to save the query results as text file
  
• Implemented a lot of functions in the Reaction GUI
  
• Inline hint infos