Advantage Developer Zone

 
 
 

Advantage Knowledgebase Item




Ref No:
061010-1807
Last Modified:
Wednesday, June 27, 2007
Product:
Advantage Clients ( General )
Category:
Error Codes
Title:
Use an ADS.INI file to resolve a 6420 error
Problem Description:
6420 - Unable to "discover" the Advantage Database Server
Solution:
This is the detailed walk-through for step 3 of the Advantage 6420 Solution Knowledge Base item located at reference number 061009-1806.
The detailed walk-through for step 4 of the Advantage 6420 Solution Knowledge Base item is located at reference number 061011-1810.

Use an ADS.INI file.

a. Configure a port for Advantage on the server computer.

Configure the port on the server using the Advantage Configuration Utility - Configuration Utility tab - Communications tab - IP Port setting (in 7.x) and LAN Port setting (in 8.x).  If you don’t have a specific port to set it to, we recommend that you set the port to 2000. This will be the configured_port referenced below. To verify that a desired port number is not already in use before configuring ADS to use that port, on the server computer click Start - click Run - type "cmd" in the popup and then press the enter key. This brings up a command window. At the prompt, type "netstat -a" without the quotes. This will list all the ports currently in use.

Disregard the Internet Port setting, as in nearly all cases it can be left at 0.

The Advantage Configuration Utility is located by default for ADS 7.x at C:\Program Files\Extended Systems\Advantage\Server\ads_cfg.exe and for ADS 8.x at C:\Program Files\Extended Systems\Advantage 8.0\Server\ads_cfg.exe.

If using Netware, the LAN_PORT will have to be configured through editing the ads.cfg file on the server. If the Advantage Database Server NLM is already loaded, you must unload then reload the NLM on the file server to use the newly changed settings.

If using Linux, the LAN_PORT will have to be configured through the ads.conf file on the server. If the Advantage daemon is already running, you must kill and then restart the daemon on the file server to use the newly changed settings.

b. Find out the server computer’s name.

On the server computer, click on Start - right click on My Computer - select Properties - click on the Computer Name tab. In the "Full computer name" will be the server computer’s name. This will be yourServerName referenced below.

c. Find out the server computer’s IP address.

On the server computer, click Start - click Run - type "cmd" in the popup and then press the enter key. This brings up a command window. At the prompt, type "ipconfig" without the quotes. Look for the line of text beginning with "IP Address. . .". The IP Address will be at the end of this line. This will be the pingable_IP_Address referenced below.

d. Ping the server computer IP address from the client computer.

On the client computer, click Start - click Run - type "cmd" in the popup and then press the enter key. This brings up a command window. At the prompt, type "ping pingable_IP_Address" without the quotes and where pingable_IP_Address is the IP address of the server.

e. Create an ADS.INI file.

Using Notepad (Start - All Programs - Accessories - Notepad), create a file named ADS.INI that contains the following:

[yourServerName]
LAN_IP= pingable_IP_Address
LAN_PORT=configured_port

All three pieces of information in the ADS.INI (yourServerName, pingable_IP_Address, and configured_port) must be valid.

The connection string that is used in your app needs to connect via yourServerName in order for the IP and port specified under yourServerName in the ADS.INI to be used.

f. Ensure visibility of the ADS.INI to the client application.

1. For the ADS.INI to be visible to Advantage, it must be located in one of the following folders. We recommend that it be placed in the application folder.

a. The application folder (for example, if you are troubleshooting with ARC, put it in the ARC folder).

b. The Windows directory folder.

c. The Windows System folder.

d. It may also be located in any folder in the client’s PATH.

To view and edit the filepaths in the PATH, click on Start - Control Panel - System - Advanced tab - Environment Variables button - select PATH under System Variables - Edit.

2. Ensure that there is only one ADS.INI file on the computer.

Click on Start - Search and follow prompts to initiate a file search for files named ADS.INI. Rename or delete all superfluous

ADS.INI files.
Was This Item Helpful?