Advantage has three connection types. Local (ALS) for the embedded server, Remote (ADS) for the client-server product and Internet (AIS) which includes encryption and compression when connecting to the client-server product. The AIS connection type is typically used when connecting across the Internet without using a VPN.
There are several configuration steps you must do to use an AIS connection type. These steps are listed below:
- Configure the Internet port on the Advantage Database Server
- Open the specified port on the firewall
- Advantage uses UDP/IP by default
- Clients can be configured to use TCP/IP see the help file for more information.
- Configure an Advantage Data Dictionary (ADD) for Internet access
- Create users with Internet access
- Add the INTERNET_IP and INTERNET_PORT settings on the client(s)
- Add a drive letter mapping for the client(s) to use
Configure the Internet Port
Use the Advantage Configuration Utility to specify which port Advantage will use when accepting AIS connections. If this port is set to 0 then connecting to the Advantage Server from the Internet is disabled. The Internet Port setting is located on the Configuration –> Communications tab.
Another consideration when connecting to Advantage with an AIS connection is latency. Response times across the Internet will be much slower than on a typical LAN and response times can vary depending on usage. The Advantage server will automatically disconnect clients that are not actively communicating with the server. To reduce the risk of an client connected across the Internet from getting disconnected you may need to adjust the Internet Client Timeout value on the server.
Configure Firewall Settings
Firewall configuration is specific to the firewall that you are using in your environment. Ensure that the port you specified in step one is open through the firewall for traffic in and out of the network. The default protocol is UDP/IP, however, the server can communicate via TCP/IP as well.
Clients will need to be configured to use TCP/IP communications. This can be specified in the ADS.INI file by setting the USE_TCP_IP setting to 1. Several clients also have a Communication Type option.
Configure an ADD for Internet Access
An ADD is required when connecting to Advantage using the AIS connection type. The ADD is used to authenticate the users when establishing the connection. You can still access any free tables which are in the same directory with the dictionary but I recommend that you use dictionary bound tables when possible.
You can choose from three levels of security; no authentication, authenticate and authenticate with encryption. You can also specify the maximum failed login attempts which allows the user the specified number of tries before locking them out of the dictionary. A database administrator must reset any locked out users.
Create Users with Internet Access
Since the dictionary is used to authenticate users when connecting with an AIS connection type these users must exist in the dictionary. Any user who needs to use an AIS connection type will need to have Internet access enabled. This is configured on the User properties screen.
Configure the Internet Address on the Client(s)
In order to connect to Advantage over the Internet from a client the client needs to know the IP address and Port to use when connecting to the server. This is specified in the ADS.INI file by specifying the INTERNET_IP and INTERNET_PORT settings for a given server name. The server name you wish to use becomes the heading for the section containing the IP and Port information.
INTERNET_IP = 10.0.0.10
INTERNET_PORT = 6263
Configure a Drive Letter Mapping
Since a client connected over the Internet cannot resolve any network shares you must either use a server-side alias or configure a drive letter mapping. The drive letter mapping is configured in the ADS.INI file under the Drives heading. The mapping must point to a share on the server name you specified when configuring the INTERNET_IP and INTERNET_PORT.
To connect the client specify the connection type to AIS or INTERNET and set the data path to the configured drive letter or server-side alias. An ADO.NET connection string would look like the following using the configuration above:
Data Source=J:\;ServerType=ADS_AIS_SERVER;User ID=Chris;Password=password;
Following these steps allows for successful connections to Advantage through the Internet.