CODEWITHSUNDEEP
sql-serverdelphicomponents
Jamo
Jamo

Reputation: 3258

Delphi 2007 Pro - Best way to connect to SQL Server

I usually use Delphi-targeted databases for most of my work (NexusDB typically, lately), but still have bad memories of how painfully slow connecting (and posting) to MS Access was via ADO. I have a new project that may need to target MS SQL Server. For D2007 Pro, what is the best way to connect to MS SQL Server? (Third party components = fine, if that's the best route).

Upvotes: 3

Views: 5344

Answers (6)

stukelly
stukelly

Reputation: 4307

Devart offer components and dbExpress drivers for accessing SQL Server databases. The also have UniDAC which supports other databases as well.

Da-soft AnyDac supports SQL Server and other databases.

Bob Swart has published Delphi for Win32 VCL Database Development on Lulu, if you need any help.

Upvotes: 1

Mohammed Nasman
Mohammed Nasman

Reputation: 11050

I always recommended DevArt db components fro their performance and reliability.

You can choose between SDAC(for direct access to sql server) or UniDac (direct access to Sql server, Oracle, MySql,PostgreSql and Interbase/firebird)

if you don't require the advanced components that access specific features of sql server like TMSChangeNotification, TMSTransaction or TMSServiceBroker, then you can go with UniDac so your application will be designed to work with multiple databases.

Upvotes: 2

da-soft
da-soft

Reputation: 7750

The AnyDAC offers great feature set and performance, as simplifies development of the database applications. AnyDAC supports MS SQL Server, MS Access and much more.

Upvotes: 3

Joe Meyer
Joe Meyer

Reputation: 448

I use ADO to connect to Sql Server since Delphi 7 and it always worked great

Upvotes: 1

Kenneth Cochran
Kenneth Cochran

Reputation: 12064

The TADOConnection really isn't that bad. Access was never intended to be a production RDBMS. ADO works much faster with SQL Server than with Access. See http://support.microsoft.com/kb/225048 for some of the reasons why.

Upvotes: 6

Charles Faiga
Charles Faiga

Reputation: 11753

The UniDac Component from DevArt / Corelab is your best option It offers fast performance and you can talk to a number of differrent databases

Upvotes: 2

Related Questions