Direct connection of Delphi XE and SQL Server 2008

Question

How to connect Delphi and SQL Server 2008?

I found an online tutorial on using SQLConnection.

The problem is that Delphi does not give me a choice of MSSQL, only Interbase / Firebird and MySql.

Is there any driver?

I know that we can use a component like Devart, but I just want to use what Delphi XE offers.

Answer 1

If you have Delphi XE Architect or Enterprise, you can connect to TSQLConnection . Since you do not see this, I assume that you have a professional SKU.

You can use ADO through TADOConnection , TADOCommand and TADOQuery to work with SQL Server in XE Pro. You will find them on the dbGo tab in the component palette.