Connect to Advantage Database Server (AnyDAC)

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.

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

AnyDAC requires the "Advantage StreamlineSQL ODBC" ODBC driver version 8.0 or higher to be installed on workstation.

You can download it from here.

Connection definition parameters

DriverID=ADS

Parameter	Description	Example value
Database	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
DefaultType	Sets the type of database files to use: "FoxPro" - FoxPro-compatible DBF/CDX/FPT files "Advantage" - Advantage-proprietary ADT/ADI/ADM files. This setting is ignored for database connections.	Advantage
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.	For example, to allow the Driver to use the remote or local server, but not the Advantage Internet Server, use:ServerTypes=3 (1+2).
Locking		For example, to allow the Driver to use the remote or local server, but not the Advantage Internet Server, use:ServerTypes=3 (1+2).
ODBCAdvanced	Allows to specify any other additional ODBC connection parameter value.	CharSet=OEM;Language=USA

DriverID=ADS
Database=c:\ads\data