![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |