The TODBCConnection component was developed originally to circumvent the strict MySQL license for applications that are not GPLed or do not obey MySQL AB's FLOSS exception.īefore you can connect to your database using ODBC, you need to install (VB.net/C# developers are recommended to use SQLClient rather than OLEDB or ODBC for the ultimate in performance, but here in Lazarus ODBC will work adequately and reliably) SQL_GUID (TGUIDField was not implemented, until recently)įreePascal ships with components for connecting to several databases, such as MySQL, PostGreSQL, Firebird, Microsoft SQL Server (since 2.6.1), Oracle, etc.įor those databases missing from the list, like MS Access and perhaps Microsoft SQL Server, ODBC is an acceptable and well established solution.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.

Postgresql odbc driver for sql server