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.

AIS Connection

4 posts in Internet Server Last posting was on 2007-01-19 10:35:29.0Z
Roger Bailey Posted on 2007-01-14 22:51:08.0Z
From: "Roger Bailey" <rbailey@northeast-cc.com>
Newsgroups: advantage.internet_server
Subject: AIS Connection
Date: Sun, 14 Jan 2007 17:51:08 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 71.10.252.243
Message-ID: <45aab2da@solutions.advantagedatabase.com>
X-Trace: 14 Jan 2007 15:46:50 -0700, 71.10.252.243
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!71.10.252.243
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:706
Article PK: 1120969

Hello,

I am working with a third party app that is connecting to the Advantage
Database.

I have setup a VPN. I can connect to the VPN fine, and see the shared drive
that I setup on the Advantage Database server to install the third party
app. I can ping the Advantage Database server's IP address. I can telnet
to the IP address and the IP port that is setup. I have setup the ADS.INI
in c:\windows. I have shutoff the firewalls on both the server and the
client.

Whenever I try to connect to the third party app, I get the 6420 error.

How do I make sure that the Advantage Database server is setup correctly?
What else do I need to check to make this connection work?

Thanks!


Joachim Duerr (ADS) Posted on 2007-01-15 09:27:40.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: AIS Connection
Newsgroups: Advantage.Internet_Server
References: <45aab2da@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <45ab490c@solutions.advantagedatabase.com>
Date: 15 Jan 2007 02:27:40 -0700
X-Trace: 15 Jan 2007 02:27:40 -0700, 130.214.79.11
Lines: 35
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:707
Article PK: 1120968


Roger Bailey wrote in <45aab2da@solutions.advantagedatabase.com>:

> I am working with a third party app that is connecting to the
> Advantage Database.
>
> I have setup a VPN. I can connect to the VPN fine, and see the
> shared drive that I setup on the Advantage Database server to install
> the third party app. I can ping the Advantage Database server's IP
> address. I can telnet to the IP address and the IP port that is
> setup. I have setup the ADS.INI in c:\windows. I have shutoff the
> firewalls on both the server and the client.
>
> Whenever I try to connect to the third party app, I get the 6420
> error.
>
> How do I make sure that the Advantage Database server is setup
> correctly? What else do I need to check to make this connection work?

a correct setting would not result in 6420 error. Please check out the
connection string and the server type.
- Does your 3rd party app use a data dictionary? This is mandatory for
AIS.
- Did you specify the INTERNET_PORT on the server? This must be a
different port than the IP_PORT setting!
- Did you enable AIS in your Data Dictionary?
- Did you enable the user for Internet Connections?

6420 means that the discovery of ADS failed, but with AIS you don't use
discovery at all. So I guess your app is not configured to use AIS.

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de


Roger Bailey Posted on 2007-01-16 19:55:16.0Z
From: "Roger Bailey" <rbailey@northeast-cc.com>
Newsgroups: Advantage.Internet_Server
References: <45aab2da@solutions.advantagedatabase.com> <45ab490c@solutions.advantagedatabase.com>
Subject: Re: AIS Connection
Date: Tue, 16 Jan 2007 14:55:16 -0500
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 209.213.76.34
Message-ID: <45ad2ca6@solutions.advantagedatabase.com>
X-Trace: 16 Jan 2007 12:51:02 -0700, 209.213.76.34
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!209.213.76.34
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:710
Article PK: 1120972

Joachim,

You are correct. The third party app is not using a data dictionary, since
they are still using DBF files, and thus AIS is not available to me.

I have a VPN established, and can connect to shared drives on the server.
Is it possible to connect to an Advantage database through a shared network
drive?

Thanks!

"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> wrote in message
news:45ab490c@solutions.advantagedatabase.com...
> Roger Bailey wrote in <45aab2da@solutions.advantagedatabase.com>:
>
>> I am working with a third party app that is connecting to the
>> Advantage Database.
>>
>> I have setup a VPN. I can connect to the VPN fine, and see the
>> shared drive that I setup on the Advantage Database server to install
>> the third party app. I can ping the Advantage Database server's IP
>> address. I can telnet to the IP address and the IP port that is
>> setup. I have setup the ADS.INI in c:\windows. I have shutoff the
>> firewalls on both the server and the client.
>>
>> Whenever I try to connect to the third party app, I get the 6420
>> error.
>>
>> How do I make sure that the Advantage Database server is setup
>> correctly? What else do I need to check to make this connection work?
>
> a correct setting would not result in 6420 error. Please check out the
> connection string and the server type.
> - Does your 3rd party app use a data dictionary? This is mandatory for
> AIS.
> - Did you specify the INTERNET_PORT on the server? This must be a
> different port than the IP_PORT setting!
> - Did you enable AIS in your Data Dictionary?
> - Did you enable the user for Internet Connections?
>
> 6420 means that the discovery of ADS failed, but with AIS you don't use
> discovery at all. So I guess your app is not configured to use AIS.
>
> --
> Joachim Duerr
> Senior Product Support Analyst (Advantage Database Server)
> iAnywhere Solutions / Extended Systems
> advantage[AT]extendsys.de


Joachim Duerr (ADS) Posted on 2007-01-19 10:35:29.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: AIS Connection
Newsgroups: Advantage.Internet_Server
References: <45aab2da@solutions.advantagedatabase.com> <45ab490c@solutions.advantagedatabase.com> <45ad2ca6@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <45b09ef1@solutions.advantagedatabase.com>
Date: 19 Jan 2007 03:35:29 -0700
X-Trace: 19 Jan 2007 03:35:29 -0700, 130.214.79.11
Lines: 33
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:711
Article PK: 1120974


Roger Bailey wrote in <45ad2ca6@solutions.advantagedatabase.com>:

> I have a VPN established, and can connect to shared drives on the
> server. Is it possible to connect to an Advantage database through a
> shared network drive?

you should be able to specify the server's ip and port in the ads.ini
file.

e.g. you connect to a mapped drive S:\mydata (where S: is mapped to
\\myadsserver\anyshare). The you can specify myadsserver in an ads.ini
file on the client:

[myadsserver]
lan_ip=192.168.1.100
lan_port=6262

ADS by default listens to port 6262 but that is not guaranteed. To
specify the port on server side, check the Advantage configuration.

btw: If you're still getting 6420, then either the ads.ini file is not
being found or the server specification (section name) is different to
the mapping (maybe mapped to an IP address rather than to the server
name). If ads.ini file is being used and the conection cannot be
established, you'll get 6097 error instead. Then you need to check the
IP address, port and maybe the firewall and router settings.


--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de