Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
Connect to Advantage Database Server
Database Connectivity  See Also  Send Feedback

Describes how to connect to Advantage Database Server.

Group

Database Connectivity

Links
Database Connectivity, See Also
Description
Supported versions

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

 

Windows client software

AnyDAC requires the ACE32.DLL x32 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 "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 
CharacterSet 
An optional collation language used when opening tables. The collation may be specified for ANSI/OEM characters, Unicode characters or both. Unicode collation name must be pre-pended with a single colon character. If both ANSI/OEM collation and Unicode collation are to be specified, the Unicode collation must be specified after the ANSI/OEM collation. 
Duden_DE_ADS_CS_AS_1252:de_DE 
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 
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 ADS database in "free connection" mode:

 

DriverID=ADS
Database=c:\ads\data

 

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

 

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

 

  • Open a client-server data dictionary based connection:

 

DriverID=ADS
ServerTypes=Remote
Protocol=TCPIP
Database=\\DA\ADS_DB\addemo.add
User_Name=adssys
Password=a
See Also
What do you think about this topic? Send feedback!