TXXXConnections are components, that take the TMySQLx圜onnection (where xy is a version number, e.g.The components allowing access to a variety of databases may be found in the Lazarus SQLdb menu. TODBCConnection specific controls will be added, as explained in the paragraphs below. Save it as MySQL1.lpi and then re-save it as MySQL2.lpi. Recent version of Lazarus, you may prefer to download the source code, using aĬreate a Lazarus application project with the form shown on the screenshot below. Click the following link toĭownload the Lazarus/Free Pascal source code of this application.

Some explanations (such DSN concerning the installation of the ODBC drivers) apply to MS Windows only. It is supposed that you are familiar with Lazarus and Free Pascal. Using a TMySQL57Connection and second, using a TODBCConnection. my article concerning the installation of MySQL on MS Windows), first, The following document shows, how to implement a simple Lazarus application, reading and displaying the number of cities in the 'world' database, installed as sample Note, that there are two popular ODBC Driver Managers for Unix-based Fortunately, MS Windows include the soĬalled Microsoft Open Database Connectivity (ODBC), an interface that makes it possible for applications to access data from a variety of database management systems.Īnd Lazarus includes the TODBCConnection object, you need to do so. What does not mean, that you can't use Lazarus with this database you just have to use a different method to connect to it. Translation needs to be made for each new version and it may be possible that you will not find a version, that actually works with the most recent MySQL distribution. This is relativelyĮasy to implement, but there is one major issue: The MySQL maintainers break binary compatibility between client library versions. The most common method to connect to MySQL from a Lazarus application is to use a TMySQLConnection object. It is possible to connect to a MySQL database as well as from Free Pascal command line programs as from Lazarus GUI applications the following document applies The Connecting to MySQL 8 paragraph at the tutorial start page may be helpful. If you experience problems with newer versions of the database,

Note: The tutorial examples have been build and tested on Windows 10, using Lazarus 1.8.4 64bit (with FPC 3.0.4) the database Connecting to a MySQL database using Lazarus/Free Pascal.

Free pascal program tutorial 1