Delphi 2007 Pro - Best way to connect to SQL Server

Question

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).

Kenneth Cochran · Accepted Answer · 2009-02-26 04:52:01Z

6

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.

answered Feb 26, 2009 at 4:52

Kenneth Cochran

12.2k4 gold badges54 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gerry Coll Over a year ago

if using TADO* without using databound controls, always call DisableControls before opening - it can be much faster.

Gerry Coll Over a year ago

p.s. It can be better to create your own subclasses, calling DisableControls in the constructor.

Fabricio Araujo Over a year ago

I use TADO* with TClientDatasets to connect MS SQL Server, no problem at all. All Access projects I've done was a maintenance project, which finished sometime ago.....

da-soft · Accepted Answer · 2010-10-16 05:46:05Z

3

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.

edited Oct 16, 2010 at 5:46

answered Feb 18, 2010 at 20:12

da-soft

7,77031 silver badges37 bronze badges

Comments

Charles Faiga · Accepted Answer · 2009-02-26 04:36:49Z

2

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

answered Feb 26, 2009 at 4:36

Charles Faiga

11.8k27 gold badges105 silver badges142 bronze badges

Comments

Mohammed Nasman · Accepted Answer · 2010-10-16 09:57:20Z

2

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.

edited Oct 16, 2010 at 9:57

answered Feb 26, 2009 at 6:54

Mohammed Nasman

11.1k7 gold badges46 silver badges68 bronze badges

Comments

oodesigner · Accepted Answer · 2011-03-28 18:26:58Z

1

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.

edited Mar 28, 2011 at 18:26

oodesigner

1,0076 silver badges8 bronze badges

answered Feb 26, 2009 at 8:21

stukelly

4,3073 gold badges40 silver badges44 bronze badges

Comments

Joe Meyer · Accepted Answer · 2010-02-19 04:30:49Z

1

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

answered Feb 19, 2010 at 4:30

Joe Meyer

4481 gold badge6 silver badges14 bronze badges

Collectives™ on Stack Overflow

Delphi 2007 Pro - Best way to connect to SQL Server

6 Answers 6

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related