ODBC or MSSQLConnection
lazarus / 16-Databases

----------------------------------------------------------------------
echi · 2021-03-04 12:29

Hello,

I have apps that connect to MSSQL via TODBCConnection. I've heard that
it is better to connect with TMSSQLConnection.
Is this true? Why is it "better"? What are differences?

Someone told me that an ODBC driver doesn't support the full set of
features that the database does...

----------------------------------------------------------------------
MarkMLl · 2021-03-04 13:08

My preference would be to use ODBC as a fairly well-supported standard
API if possible, but I've certainly come across restrictions with
PostgreSQL: I don't know whether it's been added, but Postgres has
various notification facilities which were alien to ODBC and there are
no doubt others.

MarkMLl