Access MSSQL with Lazarus

[claytonocn]

Hello!
I am a Delphi programmer and would like to migrate to Lazarus. I usually access MSSQL databases via ADO, using the components from the dbGO palette.

I would like to know which component to use in Lazarus that allows me to connect to the server without having to install or configure anything on the client PC, as I already do in Delphi.

Also, which component has the best performance and which components are compatible for compiling for Windows, Linux and Mac?

Thank you!

[Zvoni]

MSSQLConn in conjunction with FreeTDS
https://www.freepascal.org/docs-html/current/fcl/mssqlconn/index.html
https://wiki.freepascal.org/mssqlconn

[luca]

Hi.
I'm using ODBC connector (TODBCConnection).
It gives the possibility to use the last ODBC driver version to connect to SQL Server and it's portable.
You can configure the connection by using an external DSN file.

In my project I started using MSSQL 2000 migrated recently to MSSQL 2022.

Best Regards

[af0815]

As a Delphi developer, you can change to zeros, Wich is available for Delphi and Lazarus. After the Changes in Delphi, the change to Lazarus will be one point easier.

[dseligo]

zeros

You mean ZEOS (https://wiki.freepascal.org/ZeosDBO), not zeros?

[af0815]

zeros

You mean ZEOS (https://wiki.freepascal.org/ZeosDBO), not zeros?

YES. It one of the easiest way to start a convertion, because you can try to start in Delphi and work later in Lazarus with Zeos. Because the ceaveats are normal the other used components, you have to figth against. If you use third party componnets without source and no support for freepascal you have to do a very hard way, to solve the situation. Often it is better to rewrite the software and use only codeparts of the 'old' application. This is IMHO sometimes easier and faster. Depending on the old code.

[nummer8]

Recently I had to connect to a MSSQL database.
I started with ZEOS components icm with dblib.dll

https://downloads.freepascal.org/fpc/contrib/windows/

At first I used the ADO protocol but had problems with statement timeouts.
As a second atttempt I used oleDB protocol which had a variation in the connectionstring. But no problems if the statemanet took longer to produce a result.
So my advise would also be ZEOS.