Home / SAP Advantage Database Server

SAP Advantage Database Server

ADS Version Matrix and Download

Since the switch from SCN to 1DX, the main page of Advantage Database Server are no more existing, but you can still search for the old documents, blogs and questions in the archive of 1DX. If you are looking for the Version Matrix of Advantage Database Server, you can open this …

Read More »

How to Install SAP Advantage Database Server

Installation of the Advantage Database Server version 11.10.x on a Windows Operation System. Easy change afterwards of the user license on a test system Locate the Serial Number and the Validation Code in an already installed Advantage Database Server Release. Goals:     – Learn how the installation of the Advantage Database …

Read More »

Detailed Supported Platforms

Currently supported operation systems for the last 3 major versions of SAP Advantage Database Server are below: Platform 10.x (A) 11.1 12.0 Windows Server 2012 R2 N Y (B) Y Windows Server 2012 32-bit/64-bit N Y Y Windows Small Business Server 2011 N Y Y Windows Server 2008 32-bit/64-bit (incl. …

Read More »

Supported IDEs

Currently supported IDEs for the last 3 major versions of SAP Advantage Database Server are below: IDEs 10.1 (A) 11.1 12.0 Delphi 6.7 (TDataSet) Y N N Delphi 2006 Y N N Delphi 2007, 2009 Y Y Y Delphi Prism Y Y Y Delphi 2010 Y Y Y Delphi XE …

Read More »

MiddleTierConnection with the Local Server

License Notes In general, this property was added to allow an Advantage middleware type of application to increment the Advantage Database Server user count for each remote client workstation indirectly accessing the Advantage Database Server. This provides an easy way for Advantage middleware applications to abide by the Advantage Database …

Read More »

Advantage Local Server – ALS

The Advantage Local Server allows Advantage applications to access tables, index files, and memo files that are located on computers that are not running the Advantage Database Server. The Advantage Local Server does NOT provide a client/server solution in a networked environment like the Advantage Database Server does. Thus, the …

Read More »

Solid State Drives

Assuming you are using a 64-bit OS with a 64-bit version of ADS, there should be not a practical limit to the amount of memory ADS will use., but adding more memory probably is not going to help, because it almost certainly depends on your overall database size. An SSD …

Read More »

Redistributing the Advantage Local Server

The Advantage Local Server consists of a DLL (ADSLOC32.DLL), and three optionally distributed files: ADSLOC32.DLL – The Advantage Local Server DLL. Contains the core local server functionality. ADSLOCAL.CFG – The Advantage Local Server configuration file. This file is only necessary if you wish to use local server settings other than …

Read More »

ADS Memory usage

With a 64-bit version of ADS, the MAX_CACHE_MEMORY setting is not useful. The value that is affected by that config setting is a 32-bit value, so it is not possible to set it to a useful value with a 64-bit server. So the best thing to do on 64-bit machines …

Read More »

Dynamic Server Configuration

From the ADS helpfile: The CONNECTIONS, WORKAREAS, TABLES, INDEXES, and LOCKS configuration parameters control the initial amount of resources Advantage will allocate at startup. Should Advantage run out of available connections, tables, etc., it will allocate more resources to accommodate more open connections, tables, etc. Later, if those extra resources …

Read More »

How to download ADS 12 SP01 and ADS 11.1 SP30

Go to http://support.sap.com Click the “Download Software” button Choose “Installations & Upgrades” Choose “A-Z Alphabetical List of my Products” Select letter “A” From the list, scroll down and select “SAP ADS” For ADS 12.0 SP01 Select link SAP ADS 12.0 From the right side panel, select Support Packages and Patches …

Read More »

ADS 12 SP1 and ADS 11.1 SP30 Released

Service packs for both ADS 12 and ADS 11.1 contain the following installers Advantage Delphi installer Advantage .NET installer Advantage VO/Vulcan installer What’s new? Advantage Delphi Components now includes support for Delphi 10 Seattle With bug fix for AdsData access violation in Delphi XE8 caused memory leak. Advantage .NET Data …

Read More »

Replication – speed on connection

ADS uses the client engine to connect to the destination. A background process is triggered when a new record is put into the replication queue, or when a specific interval has been reached after a previous connection failure, or when you manually trigger the process (adsprocessreplicationqueue). The target only gets …

Read More »

Compare two Tables

Here’s an example: try drop table #tb1; catch all end try; try drop table #tb2; catch all end try; create table #tb1(id integer, test char(20)); create table #tb2(id integer, test char(20)); insert into #tb1(id, test) values(1,’a’); insert into #tb1(id, test) values(2,’a’); insert into #tb1(id, test) values(3,’a’); insert into #tb1(id, test) …

Read More »