CODEWITHSUNDEEP
sqldelphisql-server-2008delphi-xe
Thiago Gabriel Leite Ferreira
Thiago Gabriel Leite Ferreira

Reputation: 61

Delphi XE and SQL Server 2008 express connection

How can I connect Delphi and SQL Server 2008?

I found on the internet a tutorial teaching how to use SQLConnection.

The problem is that Delphi doesn't give me an option to select MSSQL, only Interbase/Firebird and MySql.

Is there any driver missing?

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

Upvotes: 4

Views: 4526

Answers (1)

Ken White
Ken White

Reputation: 125661

If you have Delphi XE Architect or Enterprise, you should be able to connect with TSQLConnection. Since you don't see that, I'm guessing you have the Professional SKU.

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

Upvotes: 7

Related Questions