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

[Michael Van Canneyt]

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?

Yes.

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

https://www.freepascal.org/~michael/articles/

several articles discuss SQLDB, in particular:

https://www.freepascal.org/~michael/articles/lazviddb/lazviddb.pdf

That should be enough to get you started.

Michael.