AnyDAC
ContentsIndexHome
PreviousUpNext
Connect to Advantage Database Server

Describes how to connect to Advantage Database Server.

Group
Links
Supported versions

The AnyDAC native driver supports the Advantage Database Server v 8.0 or higher. 

 

Windows client software

AnyDAC requires the ACE32.DLL x86 or ACE64.DLL x64 client library (Advantage Client Engine API) for connecting to the Advantage server or to make a local connection. Ideally, the version should be equal to the server version. The full set of the v 10.0 client files:

  • ace32.dll
  • adsloc32.dll
  • aicu32.dll
  • axcws32.dll
  • adscollate.adm
  • adscollate.adt
  • ansi.chr
  • extend.chr
  • icudt40l.dat
  • adslocal.cfg

You can download the Advantage Client Engine API from there. The installation folder includes "Redistribute" folder, containing all required redistributable files. The files may be put into a folder:

  • listed in your PATH environment variable;
  • your application EXE folder;
  • any other folder and specify in AnyDAC\DB\ADDrivers.ini:

 

[ADS]
VendorLib=<folder>\ace32.dll

 

When the ADS client library has not been properly installed, then you will get an exception when you try to connect: 

 

[AnyDAC][Phys][ADS]-314. Cannot load vendor library [ACE32.dll].
The specified module could not be found.
Check it is located in one of the PATH directories or in the application EXE directory

 

Connection definition parameters

DriverID=ADS

Parameter 
Description 
Example value 
ServerTypes 
Value is a sum of values indicating the types of Advantage Servers to which connections are attempted. The values for the servers are:
  • ADS_REMOTE_SERVER = 2
  • ADS_LOCAL_SERVER = 1
  • ADS_AIS_SERVER = 4.
Also the keywords may be used instead of numbers:
  • Remote
  • Local
  • Internet
Few types may be concatenated by '|'. The default depends on the Server and Database values:
  • When they specify the local path with a driver letter, then "Local".
  • When a remote path, then "Remote" and "Internet".
 
For example, to allow the Driver to use the remote or local server, but not the Advantage Internet Server, use:ServerTypes=3 (1+2). 
Protocol 
Specifies the communication protocol used to connect to the Advantage Database Server:
  • UDP_IP;
  • IPX;
  • TCP_IP (default value);
  • TLS.
 
TCP_IP 
Server 
The server address. 
\\ADS 
Port 
The server port. 
6262 
Database 
The fully qualified path to the computer where the data files exist and the default location of the data files. This fully qualified path must contain a drive letter or use UNC. "Database" may include Server and Port values. For remote server types the path must either use UNC or refer to the existing network share.
For "free connections", it should be a valid path name to where the data files are located (e.g., x:\data). This path is used to automatically select all tables in the specified directory. For "database connections", it should be a valid path name including the Advantage Data Dictionary file name (e.g., x:\database\mydictionary.add). 
c:\ads\data
\\ADS:6262\DB 
Alias 
Specifies the alias to be used when connecting to the database server. The file path associated with the specified alias will be used as the database directory. The table type associated with the alias will be set as the default table type for use with this connection. See Database Aliases and the ads.ini File for a full description of an Alias. 
 
CharacterSet 
An optional collation language used when opening tables. 
ANSI 
Compress 
Specifies the option for communications compression. Valid values are:
  • Internet;
  • Always;
  • Never.
 
Internet 
TableType 
Sets the type of database files to use:
  • ADT - Advantage-proprietary ADT/ADI/ADM files;
  • VFP - FoxPro-compatible DBF/CDX/FPT files;
  • CDX;
  • NTX.
This setting is ignored for database connections. 
ADT 
TablePassword 
Specifies encryption password for all tables in the connection. Applicable for free connections only. 
 
Locking 
Specifies the locking mode to use when opening DBF tables. Valid values include:
  • Proprietary - Advantage’s high-performance internal locking mode is used;
  • Compatible - DBF tables can be shared in a writeable mode with non-Advantage database applications.
 
Proprietary 
ADSAdvanced 
Allows to specify any other additional ACE API AdsConnect101 connection parameter value. 
EncryptDictionary=True;DDPassword=qwe 

 

Usage cases
  • Open local ADS database in "free connection" mode:

 

DriverID=ADS
Database=c:\ads\data

 

  • Open local ADS database in "free connection" mode with Visual FoxPro tables:

 

DriverID=ADS
Database=c:\ads\data
TableType=VFP

 

  • Open a remote data dictionary based connection:

 

DriverID=ADS
ServerTypes=Remote
Protocol=TCPIP
Database=\\DA\ADS_DB\addemo.add
User_Name=adssys
Password=a

 

  • Open local ADS database in "free connection" mode using an alias:

 

DriverID=ADS
Alias=MyConn

 

And the ads.ini content: 

 

[Databases]
MyConn=c:\data;N
What do you think about this topic? Send feedback!