SQL Server Data Access Components

Category: ASP.NET - Miscellaneous

SQL Server Data Access Components (SDAC) is a library of components that provides access to Microsoft SQL Server databases. SDAC connects to SQL Server directly through OLE DB, which is a native SQL Server interface. The SDAC library is designed to help programmers develop faster and cleaner SQL Server database applications. SDAC is a complete replacement for standard SQL Server connectivity solutions and presents an efficient alternative to the Borland Database Engine for access to SQL Server.Features: SDAC is a direct connectivity database wrapper built specifically for the SQL Server server. SDAC offers wide coverage of the SQL Server feature set and emphasizes optimized data access strategies. Wide Coverage of SQL Server Features By providing access to the most advanced database functionality, SDAC allows developers to harness the full capabilities of the SQL Server and optimize their database applications. SDAC provides complete support of working with SQL Server 2005 Compact Edition, Service Broker technology, the IRowsetFastLoad interface, working with metadata information, and MARS. Optimized Code The goal of SDAC is to enable developers to write efficient and flexible database applications. The SDAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers. Compatibility with Other Connectivity Methods The SDAC interface retains compatibility with standard VCL data access components like BDE. Existing BDE-based applications can be easily migrated to SDAC and enhanced to take advantage of SQL Server-specific features. Project migration can be automated with the BDE/ADO Migration Wizard. How Does SDAC Work? SDAC allows you to connect to SQL Server through OLE DB, which is the lowest documented SQL Server interface. SDAC connects through OLE DB through a set of COM-based interfaces. SDAC is designed to be lightweight and consists of a minimal layer between your code and SQL Server databases. In comparison, the Borland Database Engine (BDE) uses several layers to access SQL Server, and requires additional data access software to be installed on client machines. Key Features:- Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC) - VCL, VCL.NET, and CLX versions of library available - Full support of the latest Microsoft SQL Server versions, including Express and Compact Editions - Support for all SQL Server data types - Disconnected Model with automatic connection control for working with data offline - Local Failover for detecting connection loss and implicitly reexecuting certain operations - All types of local sorting and filtering, including by calculated and lookup fields - Automatic data updating with TMSQuery, TMSTable, and TMSStoredProc components - Unicode support - Support for many SQL Server-specific features, such as MARS and bulk copy operations - Advanced script execution with TMSScript component - Support for using macros in SQL - Easy migration from BDE and ADO with Migration Wizard - Lets you use Professional Edition of Delphi and C Builder to develop client/server applications Date: 17 May, 2012


Microsoft Sql Server - Database Tool - Asp Net Library - Microsoft - Sql - Server

Homepage: http://www.devart.com/

Developer: devart.com

License: Freeware

Operating System: All

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

LimeSurvey is an Open Source Online Survey Tool, which was known until May 2007 as PHPSurveyor.

developer Developer: LimeSurvey Development Team
license License: Freeware
operating systems Operating System: Platform indepentend


neo_my2pg is a Python script for migration from mysql to postgresql.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


sqlWebArchitect is a Web-Based Open Source SQL Server and MSDE Database Administration tool.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows


SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


Download Trakker masks the true address of a URL.

developer Developer: scriptsforyou.net
license License: Freeware
operating systems Operating System: All


Dataman is a fully multi-threaded database server and client API libraries in C, C , Java, and a PHP module has now been added as well.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


DBReplicator is a powerful open-source java application for network-based multi-master heterogeneous database replication or filtered synchronization.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


SWTJasperViewer is a JasperReports viewer component for SWT/JFace based applications and Eclipse plug-ins.

developer Developer: jasperassistant.com
license License: Freeware
operating systems Operating System: All


MouseTrends is a new unique solution for analyzing your visitors client side mouse events.

developer Developer: opencube.com
license License: Freeware
operating systems Operating System: All