Different methods to connect to the server Professional

Server identification

When using DacConnect() to establish a connection to the ADS Server there must be a way to identify the server. Therefore different ways are available to identify the server.

Using mapped/used drive

Using Server-Drive is the easiest way to indentify the ADS Server. However, the drawback of this approach is that the local workstation accessing the files has been forced to have the drive mapped to the file-server the ADS Server is installed on.

01: DacSession():New("DBE=ADSDBE;SERVER=F:") 

Server and share names

Using Servername and Sharename as a way to specify the server location in the connection string, the workstation accessing the server does no longer need the drive being mapped. However the user has to be successfully authentificated by the server hosting the ADS Server.

01: DacSession():New("DBE=ADSDBE;SERVER=\\ALASKA01\SOMEWHERE") 

Dictionary connection using path and filename to dictionary storage

When using Advantage Database Server 6.x or higher one can connect to the server and open a dictionary connection using the full UNC pathname and filename where the dictionary resides. If connections to the dictionary are required in most cases additional user and password authentification may be required.

01: DacSession():New("DBE=ADSDBE";SERVER=\\ALASKA01\SOMEWHERE\Product Group.add") 

Dictionary connection using alias-name

The ADS Server allows access to a dictionary without knowing the physical location of the dictionary and its related database files. To connect to the ADS Server, one must specify the alias-name of the dictionary straight after the servername. The following code illustrates this method of establishing a connection.

01: DacSession():New("DBE=ADSDBE;SERVER=\\ALASKA01\ProductGroup") 

Connections through the intranet (TCP/IP) or to Linux

Connection paths to the Advantage Database Server can also be composed out of an domain-name or ip-address and an optional port number. The port number must be specified if the ADS Server is configured to a specific port. The IP address must be used when the domain name of the server can not resolved using an available DNS service.

01: DacSession():New("DBE=ADSDBE;SERVER=\\ads70.alaska-software.com:6200\ProductGroup") 
02: DacSession():New("DBE=ADSDBE;SERVER=\\192.168.2.1:6200\ProductGroup") 

Connections through the internet

Connections through the internet (extranet) are a specific type of an TCP/IP connection. Additional attributes such as ADS_AIS_SERVER and the IP Port are necessary. The following connection string establishes a connection via the internet to the public demo server from extended systems. The ADS_AIS_SERVER connection attribute is required for internet connections, if not specified the server will refuse the connect.

01: DacSession():New("DBE=ADSDBE;"+; 
02:                  "SERVER=\\devzone.advantagedatabase.com:4001\addressdata\DD\AIS_demo.ADD;"+; 
03:                  "ADS_AIS_SERVER;UID=demo;PWD=demo;")