Describes how to connect to Advantage Database Server.
The AnyDAC native driver supports the Advantage Database Server v 8.0 or higher.
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:
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:
[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
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:
|
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:
|
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 |
|
TableType |
Sets the type of database files to use:
|
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 |
|
ADSAdvanced |
Allows to specify any other additional ACE API AdsConnect101 connection parameter value. |
EncryptDictionary=True;DDPassword=qwe |
DriverID=ADS Database=c:\ads\data
DriverID=ADS Database=c:\ads\data TableType=VFP
DriverID=ADS ServerTypes=Remote Protocol=TCPIP Database=\\DA\ADS_DB\addemo.add User_Name=adssys Password=a
DriverID=ADS Alias=MyConn
And the ads.ini content:
[Databases] MyConn=c:\data;N
|
What do you think about this topic? Send feedback!
|