SQL_INTERVAL_* (what would be the corresponding TFieldType?).SQL_TYPE_UTC* (these are mentioned in the ODBC docs, but seem not to be used in implementations).proper transaction support currently each connection corresponds to one transaction.UpdateIndexDefs (so you can use ApplyUpdates).query parameters (string and integer types).executing queries and retrieving result sets.You can also use the TODBCConnection component in your code by adding ODBCConn to your uses clause. In Lazarus, you can find the TODBCConnection component on the SQLdb component tab. TODBCConnection is an TSQLConnection descendant providing a nice OOP wrapper for ODBC using the SQLdb framework. Official ODBC documentation can be found at the MSDN ODBC site.įreePascal ships with ODBC headers they are in the odbcsql and odbcsqldyn units. There are ODBC implementations for various platforms and there are drivers for most Database Management Systems.

ODBC (Open Database Connectivity) is a technology that allows one to connect to a whole variety of databases using a single API, the ODBC API.

Latest odbc driver for sql server