SDAC2.45 1.19

SQL Server Data Access ComponentsCopyright 1997-2003, Core Lab. All Rights Reserved--------------------------------------------------SQL Server Data Access Components (SDAC) library offers a set ofnonvisual components for Borland Delphi and C++ Builder. They provideaccess to Microsoft SQL Server and are an alternative to a standardway of accessing databases using Borland Database Engine (BDE).SDAC uses OLE DB directly through a set of COM-based interfaces thatexpose data from a variety of sources. OLE DB interfaces provideapplications with uniform access to data stored in diverse informationsources, or data stores. These interfaces support the amount of DBMSfunctionality appropriate to the data store, enabling the data storeto share its data.Using BDE in SQL Server oriented client/server applications has somedeficiencies. In many cases BDE community are unable to employ serverspecific features, they must tolerate excessive usage of resources,reduced speed of processing data, restricted distribution of an applicationand its administration.Using BDE in database applications amounts to the following data pathbetween server and client:[SQL Server] <-> [DBLibrary] <-> [SQL Links] <-> [BDE] <-> [Client application]SDAC works directly through OLE DB, which is a native SQL Serverinterface. Applications with SDAC components access server directly:[SQL Server] <-> [OLE DB] <-> [Client application]Using SQL Server Data Access gives you the following advantages: - No distribution, installation and configuration is required for BDE and ODBC; - You can use any Delphi Professional Edition to develop client/server applications; - Supports SQL Server specific features: windows authentication, metadata, unicode fields, manual refresh for record in a dataset, automatic getting Identity value and results of triggers work and a lot of more; - Simplifies data updating; - Speeds up fetch of records from database; - Provides automatic refresh for records; - Advanced design time editors; - Interface (methods, properties) of SDAC components is similar to those of standard BDE data access components (TDatabase, TQuery, ..); - Supports all data-aware components; - and so on.Compatibility-------------SDAC supports SQL Server 7, SQL Server 2000 and MSDE.SDAC requires OLE DB installed on workstation.Note: in current versions of Microsoft Windows, as Windows 2000, OLE DB is already included as standard package. But it‘s highly recommended to download latest version (newer than 2.5) of Microsoft Data Access Components (MDAC) at http://www.microsoft.com/dataInstallation------------SDAC installer copies these files to folders where they should be resided. sdacXX.bpl - SDAC run-time package (located in WindowsSystem folder) dclsdacXX.bpl - SDAC design-time package (located in DelphiBin folder) sdacvclXX.bpl - VCL support package (located in DelphiBin folder) crcontrolsXX.bpl - TCRDBGrid component (located in DelphiBin folder) Delphi ====== To compile SDAC based application add $(DELPHI)SDACLib to Project Options|Search path. C++ Builder =========== To compile SDAC based application add $(BCB)SDACLib to Project Options|Library path and $(BCB)SDACInclude to Project Options|Include path.Writing GUI applications with SDAC----------------------------------Now SDAC GUI part is standalone. This means that to make available GUI elements such as sql cursors, connect form, connect dialog etc. you should explicitly include SdacVcl unit to your application. This feature is needed for writing console applications. Delphi and C++ Builder ====================== By default SDAC does not require Forms, Controls and another GUI related units. Only TMSConnectDialog component requires Forms unit.Trial version restrictions--------------------------Note following restriction when using SDAC trial version.When SDAC based application is running IDE should be also running.Using several products in one IDE---------------------------------SDAC, ODAC and MyDAC components use common base packages listed below. dacXX.bpl dacvclXX.bpl dcldacXX.bplNote that product compatibility is provided for current build only.In the other words, if you upgrade one of the installed products itmay conflict with older builds of other ones. In order to continue usingproducts simultaneously you should upgrade all of them at the same time.--------------------http://www.crlab.comsdac@crlab.com