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).
Indeed, SDAC (or UniDAC if you don't want to tie the app to MS Sql Server) are the way to go. +1.
mghie
2009-02-26 04:37:19
+2
A:
The UniDac Component from DevArt / Corelab is your best option It offers fast performance and you can talk to a number of differrent databases
Charles Faiga
2009-02-26 04:36:49
+5
A:
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.
codeelegance
2009-02-26 04:52:01
if using TADO* without using databound controls, always call DisableControls before opening - it can be much faster.
Gerry
2009-02-26 07:54:17
p.s. It can be better to create your own subclasses, calling DisableControls in the constructor.
Gerry
2009-02-26 07:55:24
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.....
Fabricio Araujo
2009-02-27 18:57:51
+2
A:
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.
Mohammed Nasman
2009-02-26 06:54:23
+2
A:
Devart offer components and dbExpress drivers for accessing SQL Server databases. The also have UniDAC which supports other databases as well.
RemObjects AnyDac supports SQL Server and other databases.
Bob Swart has published Delphi for Win32 VCL Database Development on Lulu, if you need any help.
stukelly
2009-02-26 08:21:02
Jamo
2009-02-27 14:54:57
+1
A:
I use ADO to connect to Sql Server since Delphi 7 and it always worked great
Joe Meyer
2010-02-19 04:30:49