Faster SQL Server connectivity It can connect to server using SQL Native Client ODBC and similar APIs are not required Supports different IDEs Works on both 32 and 64-bit platforms Compatible with different SQL Server versions
Cons
None
DbExpress driver for SQL Server
Price: $
If you are looking for a faster solution for connecting to SQL Server from Delphi development environment than the ones provided by default, then dbExpress driver for SQL Server might be the solution you are looking for.
Upon installation, besides installing dbExpress driver for SQL Server, you will be also able to install demos, to help you get started, and also an Advanced SQLConnection component. And, if you wish to track query executions, you can also install an external solution available for that purpose, called dbMonitor.
dbExpress driver for SQL Server works as an independent library for connecting to SQL Server from Delphi and C++ Builder IDE, and because of its simplicity by design, it can offer faster SQL Server connectivity. Also, it can be used just like default solutions provided by the IDE.
It relies on OLE DB for its functioning, which is required to be installed on the system with SQL Server. In addition, besides using OLE DB for connection, it can also connect to server using SQL Native Client. Other APIs, such as ODBC, are not required for the driver to function, and that is also the reason why it can work faster than default connectivity solutions provided by the IDE.
dbExpress driver for SQL Server can be used from different development environments, such as RAD Studio, Delphi, C++Builder and FireMonkey platform, and works on both 32 and 64-bit systems. It is also compatible with different SQL Server versions, from 2000 to 2016, including SQL Server Compact and SQL Azure.
Reviewed by Tony Hill (editor rating 4.5 out of 5 stars)