[Lazarus] Porting Delphi (2007/XE5) application, how to handle ADODB?

Michael Van Canneyt michael at freepascal.org
Mon Jan 23 09:59:14 CET 2023

On Mon, 23 Jan 2023, Bo Berglund via lazarus wrote:

> I have a number of "older" applications developed on Windows using
> Delphi7-2007-XE5, which use ADODB for database accesses.
> The database is Microsoft SQLSERVER.
> Now I no longer have the old Borland software installed (issues with Windows 10
> etc) so I want to port the projects to FPC/Lazarus.
> I have ported some other non-database applications which (with some effort)
> seems to have worked out OK.
> Now I am facing the challenge of doing it on an adodb database enabled
> application and I would like to know if there is some "compatible" way of doing
> it, which is described somewhere?


You need to use SQLDB, and the TMSSQLConnection.

See https://wiki.freepascal.org/SQLdb_Tutorial1 for a simple explanation.

The page https://wiki.freepascal.org/SQLdb_Package also contains some explanations
for setup.

There are some other pages in the wiki.

A more in-depth explanation is in the lazarus book.

Or you can look at


several articles discuss SQLDB, in particular:


That should be enough to get you started.


More information about the lazarus mailing list