Oracle Clients: 12c, 11g, 10g, 9i, 8i, 8.0.ĭownload MySQL 32/64 bit ODBC driver - latest version of MySQL ODBC driver which supports Windows, Mac OS X, Linux both on 32 and 64 versions. Compatible with Oracle servers: 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g. Works on all Lazarus versions.ĭownload Oracle 32/64 bit ODBC driver - latest version of Oracle ODBC driver which supports Windows, Mac OS X, Linux both on 32 and 64 versions. Compatible with SQL Server 2014\2012\2008 R2\ 2008\2005 (including Express edition), SQL Server 2000 (including MSDE), SQL Server 7, SQL Server Compact 4.0\3.5\3.1. You can download latest ODBC drivers using the following links:ĭownload SQL Server 32/64 bit ODBC driver - latest version of SQL Server ODBC driver which supports Windows, Mac OS X, Linux both on 32 and 64 versions. Note: the unixodbc-bin package might not be available from the default package repository. If you installed the unixodbc-bin package, you can run the ODBCConfig program to configure ODBC drivers and DSNs.įor Ubuntu, follow the instruction for Debian. install the unixodbc-dev package, which does create the symlink.create the link yourself: ln -s libodbc.so.1 /usr/lib/libodbc.so, or.It will not accept a file named like libodbc.so.1 or libodbc.so.1.0.0.ĭebian's unixodbc package does not create a symlink with the name /usr/lib/libodbc.so you must either The odbcsqldyn unit, and hence odbcconn, will search for a file called libodbc.so. ODBCConn is known to work with unixODBC iODBC compatibility still has to be tested.įor Debian, you can install the unixodbc package:Īptitude install unixodbc-bin # if you want some GUI tools Two popular ODBC Driver Managers for Unix-based platforms are unixODBC and iODBC. You can, of course, create a desktop shortcut to the ODBC dialog if you find yourself using it frequently. Or you may simply click the Start button and enter ODBC into the Run box (in Windows 7 this appears as " Search programs and files"). It is found in the Control Panel, in later Windows versions with categorised sections it was moved into the Administrative Tools area. Windows has an ODBC Driver Manager built in, which allows DSNs to be set up, and other configuration. However, please consult the relevant documentation for a definitive reference. This section will give a brief overview of the steps involved. an ODBC driver specific to the DBMS you want to connect to.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.
0 Comments
Leave a Reply. |