What is ODBC?
ODBC stands for Open Data Base Connectivity. Open Database Connectivity 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.
What is SQL?
SQLis an acronym for Structured Query Language. It is a database query language that was adopted as an industry standard in 1986.
Applications
iODBC is a port of the iODBC driver manager. This library manages drivers for different databases (local or remote) on behalf of applications to allow transparent connectivity to different database architectures. iODBC supports ODBC 3 and users of earlier versions might find slight changes to the API have been introduced. This is due to differences in the ODBC 2.5 and 3 specifications and is not a limitation of iODBC itself.
ODBCMan allows you to easily manage ODBC configuration on your computer.
New drivers can be quickly and easily installed and once a Datasource has been set up any ODBC compliant application can see it and connect to your database whether it be running locally on or a remote machine.
SQLTool provides an easy way to run simple SQL queries against any ODBC compatible database.
The results of a query can be saved to other applications as plain text, CSV or TSV files.
Drivers
PostgreSQL
A port of the ODBC driver from the PostgreSQL relational database.
MyODBC
A port of the MyODBC ODBC driver for the MySQL relational database.
FreeTDS
A port of the ODBC driver from the FreeTDS library giving access to SyBase and Microsoft SQL Server databases.
SQLite
A port of the ODBC driver for the SQLite embedded database.
© Copyright 1995-2018 Richard Windley and Broad Oak Studios
Contact Us | Privacy | Cookies