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. -- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
