Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

New Installation Procedure

2 posts in Internet Server Last posting was on 2005-03-21 11:48:14.0Z
Benedictum Posted on 2005-03-17 16:55:18.0Z
From: "Benedictum" <dominus@vobis.com>
Newsgroups: Advantage.Internet_Server
Subject: New Installation Procedure
Date: Thu, 17 Mar 2005 10:55:18 -0600
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 68.255.106.146
Message-ID: <4239b76f@solutions.advantagedatabase.com>
X-Trace: 17 Mar 2005 09:59:27 -0700, 68.255.106.146
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.255.106.146
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:598
Article PK: 1120861

I am going to relate here what I went through in installing the ADS
"system":
1. a) Created folder named on d:drive as "data2005" and copied dbf/ntx files
into it.
b) Installed the 30-day trial with the provided license and key entered.
..enabled internet access. Here is where I got confused. IP
Port and Internet Port. I do not know the difference between the two.
Anyway, I proceeded with IP Port = 2600 and Internet Port=6262. Need to
explain this to me I found nothing in the help documentation.

2. Installed ARC. Created the database dictionary. Added one user only
(besides the AdsSys). Other than the location of the dbf/ntx files I did not
add the tables into the data dictionary (I want the files as free tables). I
named the dictionary as "medical.add" with an alias of "clipmoms". How am I
doing so far?

3. Firewall/router configuration - opened the port 6262 as UDP/IP and
forwarded it to the LAN IP of the server machine.

4. Acquired the WAN IP.

5. On the Client side, I ran ARC and created a database
as "InClipMoms" with connection path as \\wan
ip:6262\d:\data2005\medical.add then tried opening the database --- I could
not access the server.

Please review what I did and make any correction or suggestions.

Thanks


Alphonsos Pangas Posted on 2005-03-21 11:48:14.0Z
From: "Alphonsos Pangas" <tech@synpan.gr>
Newsgroups: Advantage.Internet_Server
References: <4239b76f@solutions.advantagedatabase.com>
Subject: Re: New Installation Procedure
Date: Mon, 21 Mar 2005 13:48:14 +0200
Lines: 102
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
NNTP-Posting-Host: 62.103.71.231
Message-ID: <423eb575@solutions.advantagedatabase.com>
X-Trace: 21 Mar 2005 04:52:21 -0700, 62.103.71.231
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!62.103.71.231
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:599
Article PK: 1120862

I am still in the same stage as you, more or less (testing with an
evaluation ID), so there may be some gaps in my understanding, but here are
a few suggestions:

> I am going to relate here what I went through in installing the ADS
> "system":
> 1. a) Created folder named on d:drive as "data2005" and copied dbf/ntx
files
> into it.
> b) Installed the 30-day trial with the provided license and key
entered.
> ..enabled internet access. Here is where I got confused. IP
> Port and Internet Port. I do not know the difference between the two.
> Anyway, I proceeded with IP Port = 2600 and Internet Port=6262. Need to
> explain this to me I found nothing in the help documentation.

I understand that IP port is meant to be used with the LAN_PORT/LAN_ADDRESS
settings in the client-side ads.ini file, and Internet port is meant to be
used with the INTERNET_PORT/INTERNET_ADDRESS settings. But they seem to be
interchangeable, at least when accessing the server with the Advantage Data
Architect. Then again, depending on the software you will use to access the
database (after the initial testing with the Advantage Data Architect), you
may find yourself forced to use one or the other setting.

>
> 2. Installed ARC. Created the database dictionary. Added one user only
> (besides the AdsSys). Other than the location of the dbf/ntx files I did
not
> add the tables into the data dictionary (I want the files as free tables).
I
> named the dictionary as "medical.add" with an alias of "clipmoms". How am
I
> doing so far?
>
> 3. Firewall/router configuration - opened the port 6262 as UDP/IP and
> forwarded it to the LAN IP of the server machine.
>
> 4. Acquired the WAN IP.
>
> 5. On the Client side, I ran ARC and created a database
> as "InClipMoms" with connection path as \\wan
> ip:6262\d:\data2005\medical.add then tried opening the database --- I
could
> not access the server.

Is the server running on a windows pc? If so, you might want to try
replacing the above connection path with \\wan
ip:6262\d$\data2005\medical.add.

>
> Please review what I did and make any correction or suggestions.

If I were you, I would take things one at a time:
*******
a) Connect to the demo data base in the Extended Systems site, and play a
little with the Advantage Data Architect, to make sure I understand how it
works. The settings needed are:

server: \\devzone.advantagedatabase.com:4001\addressdata\DD\AIS_demo.ADD
User Id: demo
password: demo

You can add the following lines to your ADS.INI file, and connect to the
server using the alias name:

[AdvantageTest]
INTERNET_IP=devzone.advantagedatabase.com
INTERNET_PORT=4001

[Databases]
AIS_demo=\\devzone.advantagedatabase.com:4001\addressdata\DD\AIS_demo.ADD;D
AIS_demo_1=\\AdvantageTest\addressdata\DD\AIS_demo.ADD;D

In the Data Architect, press Ctrl+D, then check "Alias" and select from the
drop-down list.
After doing that, you can disconnect and reconnect using a path instead of
an alias.

********
b) Try to connect to your server from within your LAN, using the local ip
address of the server machine, to eliminate the possibility of
router/firewall problems.
If you have problems doing so, you might want to check if you have any
firewall software intalled in the server machine (for example, if you are
running the ADS under win XP, the windows firewall is enabled by default).
If so, open the two ports (the one specified in "IP port" and the one
specified in "Internet port" for UDP/IP.
********

c) After connecting to the server from within your LAN, you can then attempt
doing so via an internet connection. It would be better to do so from a PC
OUTSIDE your LAN - that is, NOT one that connects to the Internet via the
same router as your server PC. You might also find it useful to repeat your
step 3 for port 2600 (the port you specified in IP Port). When you manage to
connect to your server via the internet, you can go back and close any
unneeded ports in the firewalls, etc.

Hope this helps,
Alphonsos Pangas
SYNPAN software