SQL Server Data Access Component (SDAC) Introduction
Translation: nxyc_twz@163.com
SQL Server Data Access Components 2.40 Copyright 1997-2003, Core Lab. Keep all copyright ------------------------------------------------------------------------------------------------------------------------ ----------------- SQL Server Data Access Component Library (SDAC) provides an unconstraid component set for Borland Delphi and C Builder. As an option, you can use SDAC to access Microsoft SQL Server as using BDE. SDAC uses OLE DB to access data sources directly through COM-based interface. The OLE DB interface provides a unified way for applications store data stored in different information or data sources. These interfaces support most of DBMS, and data storage and data sharing can be implemented. There are many shortcomings using BDE to develop SQL Server-based client / server applications. In many cases, BDE cannot use some of the specific functions of the server, they must use more resources, which results in reduced data processing speed and limits the distribution of applications and their management. When developing a database application using BDE, the server and the client are usually connected by the following manner: [SQL Server] <-> [dblibrary] <-> [SQL LINKS] <-> [BDE] <-> [customer application Program] SDAC works in the OLE DB mode, based on the local SQL Server interface. Using SDAC's application can access the server directly. [SQL Server] <-> [OLE DB] <-> [Customer Application] Use SQL Server Data Access Components to provide you with the following advantages:
- No need to distribute, install, and configure BDE and ODBC; - You can use any Delphi Professional to develop client / server applications; - Support SQL Server special features: Windows authentication, metadata, unicode field, manual refresh data set Record, automatically use the trigger to keep the data consistency, and other etc; - simple data update; - High-speed database record access; - Provide record automatic refresh; - Advanced design editor; - SDAC component interface (method) , Attributes are very similar to the standard BDE data access components; - support all data set components; - tolerance ... Compatibility ------------ SDAC supports SQL Server 7, SQL Server 2000 and MSDE.SDAC need to install OLE DB on the workstation. Note: In the current Microsoft Windows, such as Windows 2000 versions, OLE DB has been included as a standard package. But we still recommend you to http://www.microsoft.com/data to download the latest (after version 2.5) Microsoft Data Access Components (SDAC). Install ------------ SDAC installer Copy these files to the appropriate installation folder: SDACXX.BPL - SDAC Run (installed to Windows / System folder) Dclsdacxx.bpl - SDAC design package (Installation to Delphi / Bin folder) SDACVCLXX.BPL - VCL Support Pack (Install to Delphi / Bin folder) CRCONTROLSXX.BPL - TCRDBGRID Components (installed to Delphi / bin folder) Delphi ====== To compile SDAC's application, you need to add $ (Delphi) / SDAC / LIB to the project Options | Search Path .c builder =========== To compile SDAC-based applications, you need $ ( BCB) / SDAC / LIB is appended to the engine Options | Library Path, and add $ (bcb) / sdac / include Path to Engineering Options | Include Path. Write the GUI app with SDAC --------- ------------------------- Now the SDAC GUI section is independent. That is to say, you should make the GUI elements, such as SQL cursors, connect forms, connection dialogs, etc., you should clearly declare the SDACVCL unit in your application. This feature is necessary for writing console applications. Delphi and C Builder ====================== In the case, SDAC does not require forms, controls, and other GUI-related units. Only the TMSConnectDialog component requires a form unit. Preview of the limit -------------------------- Note: There will be the following limitations when using the SDAC preview. SDAC-based applications can only run in an IDE environment. Use multiple products in the same IDE ------------------------------- SDAC, ODAC, and MyDac components are used. The public base package listed below: Dacxx.bpldacvclxx.bpldCldacxx.bpl Note: The compatibility of these products is only valid in the same versions.
