Save 10% ordering this product in discounts:
Create feature-rich windows applications with many new components and universal dialogs.
- improved DBGrid
- new DBRecordView, DBTreeView
- toolbars and db dialogs to Find, Filter, Sort, Export, Print...
- StringGrid with columns definition
- GroupBox with automatic alignment and resizing of owned controls
And many more from $25 to $95 only - click for details!
SDAC - SQL Server Data Access Components v.8.2.9
By Devart.
05 Jun 2019Description
SQL Server Data Access Components (SDAC) is a library of components that provides access to Microsoft SQL Server databases from Embarcadero RAD Studio 10.3 Rio, RAD Studio 10.2 Tokyo, RAD Studio 2010-XE8, CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, Turbo Delphi for .NET Professional, Turbo C++ Professional, Borland Delphi 2005, Borland Delphi 7/6, Borland C++Builder 6, Lazarus 1.8.4 and Free Pascal 2.6.4 for Win32 and Win64 platforms.
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.
Key Features:
- Win64 development support
- VCL, LCL and FMX versions of library available
- Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
- Full support of the latest Microsoft SQL Server versions, including Express and Compact editions
- Support for all SQL Server data types
- Includes provider for UniDAC Standard Edition
- Disconnected Model with automatic connection control for working with data offline
- Local Failover for detecting connection loss and implicit re-execution of 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
- Advanced script execution features with TMSScript component
- Support for using macros in SQL
- Enhanced support for User-defined Types of SQL Server
- Easy migration from BDE and ADO with Migration Wizard
- Allows users to use Professional Edition of Delphi and C++Builder to develop client/server applications
Informations
- Status: Trial (work while IDE is running)
- Source: On purchase/registration
- price: $199.95
- Source price: $499.95
- Size: 4 125kB
Platforms: D2006, C2k7, D2007, C2k9, D2009, C2k10, D2010, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8, C10, D10, C10.1, D10.1, C10.2, D10.2, C10.3, D10.3, D6, D7, CB6, FM
MS SQL Headers v.1.0
By Ed Lyk.
Freeware + source 02 Sep 1997Description
"Ever wanted to use Delphi with MS SQL server without the heartache of setting up the BDE or ODBC or SQL Links? Every wanted 'really fast' database access? I did, so I set out to convert the huge MS SQL C headers for use with Delphi."Informations
- Status: Fully functional
- Source: Included
- Size: 20kB
Platforms: D1, D2, D3
MSSQL DAC v.2.55
By Gregor Markowski.
Freeware 17 Dec 2009Description
The suite of eight data-aware components:- TSQLCE_Database
- TSQL_Database
- TSQL_Dataset
- TSQL_UpdateSQL
- TSQL_Query
- TSQL_StoredProc
- TSQL_Function
- TSQL_CreateAlterDrop
You will be amazed at the potentiality and efficiency of MSSQL DAC components that set a new standard, unattainable for other components being usually heavy, overgrown and complicated. TSQL_Dataset is the only dataset component that besides simplest (and slowest together) static data access method, supports dynamic data access and partial (growing) records fetching (IN MANY CASES EVEN HUNDREDS TIME FASTER THEN STATIC METHOD; see Readme.txt and Readme_comparision.txt for more details).
TSQLCE_Database is a component for access of Microsoft SQL Servers Compact Edition ver 3.x; important properties:
- ClientDriver: (cdAutoDetect, cdSqlSrvCe__3_5, cdSqlSrvCe__3_0);
- the best way is to install both versions (3.1 and 3.5) and to use the default cdAutoDetect value, because TSQLCE_Database will choose for You the proper driver to connect to the database
- ConnectOptions: a set of three options
- coCreateIfNotExists
- coCreateEncrypted
- coOpenExclusive
for customizing the behavior of TSQLCE_Database during establishing
connection to the database
At design time TSQL_Database detects all running MS SQL Servers very fast and let You choose server and instance name from the drop down list of ServerName property.
TSQL_StoredProc :
- implemented all MS SQL Server procedure features i.e. output parameters and multiple rowsets
- returned rowsets (if any) can be accessed (at run-time only) by public property
- Rowsets[RowsetNo] : TSQL_Dataset
- published property FreeRowsetOn_CDS_read: applied when a Rowset is used as data supplier for ClientDataSet - if set to True (default) then all stored records are released from memory after ClientDataSet has finished getting records from the rowset
- preparing and unpreparing is performed automatically
- the only thing You need to do is to assign parameter values and call ExecProc method
- the fastest SQL Server data access (when Unidirectional = True, also as replacement for all dbExpress drivers; when used as data supplier for ClientDataSet, TSQL_Dataset automatically sets Unidirectional to True and allocates 0 bytes for fetched records)
- one component for all recordsets, ReadOnly and not ReadOnly i.e. physical Tables
- You can also select from Table-valued functions, for example: SELECT * FROM aTable_ValuedFunction(:par_1,:par_2,:par_3,:par_N)
- public property TableValuedFunction lets You choose required function from the dropped down list at designtime
- published property SQLStatement is divided into four sections: SELECT...FROM... , WHERE , GROUP BY , ORDER BY
- statements based on one table with joined other recordsets ARE TREATED AS TABLES i.e. NOT READONLY DATASETS
- three strategies for accessing of data:
- daStaticAccess (nonTable Datasets are always accessed in this manner) - all fields of fetched records are stored in memory; this is the conventional and the slowest method of data access)
- daDynamicAccess - purely record identifying fields are stored in memory (if there is no primary/unique key / Identity field for the table then it is marked as ReadOnly)
- daPartialFetch - all fields are stored in memory but records are fetched and appended in progressive manner during each call of one of search method (i.e. Locate, LocateNearest, FindKey, FindNearest) so You have the guarantee that searched records are fetched
- in dsInsert state, TSQL_Dataset assigns for You MasterFields values to appropriate LinkedFields automatically
- You can use Borland Field Link Designer at design-time to set relationship between master-detail fields
- decimal fields up to size 38.x (stored in packed format with minimum memory allocation as well)
- each SQL_VARIANT fields is created as TmVariantField (a little bit improved TVariantField descendant) and handled (read and write) as native SQL type, for example even if field value is set AsString = '2001-01-01 12:34:56' it wil be stored as SQL_DATETIME
Informations
- Status: Trial (work while IDE is running)
- Source: None
- Size: 1 089kB
Platforms: D2006, D2007, D6, D7
OleDb Express v.2.0.0.3
By V.V. Vassiliev.
17 Jul 2007Description
OleDb Express is dbExpress driver for MS SQL Server, MS Access, MS Excel and other OLEDB providers. It works with not all oledb providers. To work with OLEDB Express OLEDB provider must be able to determine command parameters from command text and support convertion of string data to/from BSTR.Informations
- Status: Evaluation (time-limit)
- Source: On purchase/registration
- price: $49.95
- Size: 771kB
Platforms: CB6, D2005, D2006, D6, D7
Sql Server Explorer v1.0.0
By Norbert Mereg.
Freeware + source 12 Mar 2008Description
This component explore and displays available Microsoft SQL Servers in you network.Explored informations:
- Server name
- Instance name
- Server version
- Is clustered
- IP address
- Named pipe
- used TCP port.
Informations
- Status: Fully functional
- Source: Included
- Size: 945kB
Platforms: D6