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.

how to solve this?

8 posts in Networking Last posting was on 2007-01-22 23:45:35.0Z
Sobari Tanuwijaya Posted on 2007-01-18 20:28:42.0Z
Date: Fri, 19 Jan 2007 03:28:42 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: how to solve this?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.13.2
Message-ID: <45afd82b@solutions.advantagedatabase.com>
X-Trace: 18 Jan 2007 13:27:23 -0700, 125.163.13.2
Lines: 30
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.13.2
Xref: solutions.advantagedatabase.com Advantage.Networking:681
Article PK: 1132101

Hi,
I'm confused to what has happen to my computer.
I installed ads on my notebook (it use xp home)
when I put this:

[Databases]
SPOS_MasterDb=d:\data\Dictionary\SPOSMasterDb.add;D

on ads.ini file, I can get the remote connection

but when I change to this:

[DATA_SVR]
LAN_IP=192.168.2.100
LAN_PORT=5000

[Databases]
SPOS_MasterDb=\\DATA_SVR\Dictionary\SPOSMasterDb.add;D

it said it unable to discover the advantage database server.

What should I do to fix it?

Note: the firewall on my xp is on

Thanks in advance.

-- Tanu --
I can get the database if access it directly using the drive folder type
connection, but when


Mark Wilkins Posted on 2007-01-19 00:11:13.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.Networking
References: <45afd82b@solutions.advantagedatabase.com>
Subject: Re: how to solve this?
Date: Thu, 18 Jan 2007 17:11:13 -0700
Lines: 54
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; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45b00b9e@solutions.advantagedatabase.com>
X-Trace: 18 Jan 2007 17:06:54 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Networking:682
Article PK: 1132100

Hi,

You either need to have a share defined or use server-side aliases. For
example if d:\data is a shared folder, then I think your [Databases] entry
would need to include the share name:

SPOS_MasterDb=\\DATA_SVR\DATA\Dictionary\SPOSMasterDb.add;D

If d:\data is not shared, you can define an alias (look up "server-side
aliases" in the help file) that points to the directory. If so, then the
second name in the UNC path must be the alias name. For example, if the
alias was named ALISNAME and pointed to d:\data, then it would be this:

SPOS_MasterDb=\\DATA_SVR\ALIASNAME\Dictionary\SPOSMasterDb.add;D

HTH,
Mark Wilkins
Advantage R&D

"Sobari Tanuwijaya" <tanuwijaya@gmail.com> wrote in message
news:45afd82b@solutions.advantagedatabase.com...
> Hi,
> I'm confused to what has happen to my computer.
> I installed ads on my notebook (it use xp home)
> when I put this:
>
> [Databases]
> SPOS_MasterDb=d:\data\Dictionary\SPOSMasterDb.add;D
>
> on ads.ini file, I can get the remote connection
>
> but when I change to this:
>
> [DATA_SVR]
> LAN_IP=192.168.2.100
> LAN_PORT=5000
>
> [Databases]
> SPOS_MasterDb=\\DATA_SVR\Dictionary\SPOSMasterDb.add;D
>
> it said it unable to discover the advantage database server.
>
> What should I do to fix it?
>
> Note: the firewall on my xp is on
>
> Thanks in advance.
>
> -- Tanu --
> I can get the database if access it directly using the drive folder type
> connection, but when


Sobari Tanuwijaya Posted on 2007-01-20 03:31:07.0Z
Date: Sat, 20 Jan 2007 10:31:07 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: how to solve this?
References: <45afd82b@solutions.advantagedatabase.com> <45b00b9e@solutions.advantagedatabase.com>
In-Reply-To: <45b00b9e@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.25.26
Message-ID: <45b18cb0@solutions.advantagedatabase.com>
X-Trace: 19 Jan 2007 20:29:52 -0700, 125.163.25.26
Lines: 17
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.25.26
Xref: solutions.advantagedatabase.com Advantage.Networking:685
Article PK: 1132104


Mark Wilkins wrote:
> Hi,
>
> You either need to have a share defined or use server-side aliases. For
> example if d:\data is a shared folder, then I think your [Databases] entry
> would need to include the share name:
>
> SPOS_MasterDb=\\DATA_SVR\DATA\Dictionary\SPOSMasterDb.add;D

oops, I think I forget to do that (inserting the data folder to the path).
It works now, thanks.

> If d:\data is not shared, you can define an alias (look up "server-side
> aliases" in the help file) that points to the directory.

Sorry, which help file you mean? ads help file? I try to find the
server-side aliases on the search with nil result.


Mark Wilkins Posted on 2007-01-22 15:34:31.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.Networking
References: <45afd82b@solutions.advantagedatabase.com> <45b00b9e@solutions.advantagedatabase.com> <45b18cb0@solutions.advantagedatabase.com>
Subject: Re: how to solve this?
Date: Mon, 22 Jan 2007 08:34:31 -0700
Lines: 13
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; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45b4d883@solutions.advantagedatabase.com>
X-Trace: 22 Jan 2007 08:30:11 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Networking:687
Article PK: 1132106

Hi,

It should be in the ADS help file. Are you using v7.x or earlier? Support
for server-side aliases was added in v8.0.

Mark Wilkins
Advantage R&D

>
> Sorry, which help file you mean? ads help file? I try to find the
> server-side aliases on the search with nil result.


Sobari Tanuwijaya Posted on 2007-01-22 23:45:35.0Z
Date: Tue, 23 Jan 2007 06:45:35 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: how to solve this?
References: <45afd82b@solutions.advantagedatabase.com> <45b00b9e@solutions.advantagedatabase.com> <45b18cb0@solutions.advantagedatabase.com> <45b4d883@solutions.advantagedatabase.com>
In-Reply-To: <45b4d883@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.18.10
Message-ID: <45b54c59@solutions.advantagedatabase.com>
X-Trace: 22 Jan 2007 16:44:25 -0700, 125.163.18.10
Lines: 14
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.18.10
Xref: solutions.advantagedatabase.com Advantage.Networking:688
Article PK: 1132107

IC, I still use the v 7.1.
Thanks for the info.

Mark Wilkins wrote:
> Hi,
>
> It should be in the ADS help file. Are you using v7.x or earlier? Support
> for server-side aliases was added in v8.0.
>
> Mark Wilkins
> Advantage R&D
>
>> Sorry, which help file you mean? ads help file? I try to find the
>> server-side aliases on the search with nil result.


Joachim Duerr (ADS) Posted on 2007-01-19 10:43:28.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: how to solve this?
Newsgroups: Advantage.Networking
References: <45afd82b@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: <45b0a0d0@solutions.advantagedatabase.com>
Date: 19 Jan 2007 03:43:28 -0700
X-Trace: 19 Jan 2007 03:43:28 -0700, 130.214.79.11
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Networking:683
Article PK: 1132102


Sobari Tanuwijaya wrote in <45afd82b@solutions.advantagedatabase.com>:

> [DATA_SVR]
> LAN_IP=192.168.2.100
> LAN_PORT=5000
>
> [Databases]
> SPOS_MasterDb=\\DATA_SVR\Dictionary\SPOSMasterDb.add;D
>
> it said it unable to discover the advantage database server.

what's the exact error code? If 6420, then these settings in the
ads.ini file are not being read. If 6097, then check your firewall
settings (allow incoming UDP and TCP on port 5000). Ohh...and don't
forget to specify your ADS to use that port, too.

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


Sobari Tanuwijaya Posted on 2007-01-20 03:28:25.0Z
Date: Sat, 20 Jan 2007 10:28:25 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: how to solve this?
References: <45afd82b@solutions.advantagedatabase.com> <45b0a0d0@solutions.advantagedatabase.com>
In-Reply-To: <45b0a0d0@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.25.26
Message-ID: <45b18c10@solutions.advantagedatabase.com>
X-Trace: 19 Jan 2007 20:27:12 -0700, 125.163.25.26
Lines: 27
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.25.26
Xref: solutions.advantagedatabase.com Advantage.Networking:684
Article PK: 1132103


Joachim Duerr (ADS) wrote:
>> [DATA_SVR]
>> LAN_IP=192.168.2.100
>> LAN_PORT=5000
>>
>> [Databases]
>> SPOS_MasterDb=\\DATA_SVR\Dictionary\SPOSMasterDb.add;D
>>
>> it said it unable to discover the advantage database server.
>
> what's the exact error code? If 6420, then these settings in the
> ads.ini file are not being read. If 6097, then check your firewall
> settings (allow incoming UDP and TCP on port 5000). Ohh...and don't
> forget to specify your ADS to use that port, too.
>

In my case it is 6420, I try the setting to test before I put it on the
real server.
sorry I don't get it, what do you mean with the ads.ini file are not
being read? the application cannot find the ads.ini or the application
cannot find the key located on the ads.ini?

You said that if it is 6097 the firewall should be configured to allow
UDP and TCP, so if I just allow the TCP, it still will give the 6097
error code?
Thanks.


Joachim Duerr (ADS) Posted on 2007-01-22 08:47:35.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: how to solve this?
Newsgroups: Advantage.Networking
References: <45afd82b@solutions.advantagedatabase.com> <45b0a0d0@solutions.advantagedatabase.com> <45b18c10@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: <45b47a27@solutions.advantagedatabase.com>
Date: 22 Jan 2007 01:47:35 -0700
X-Trace: 22 Jan 2007 01:47:35 -0700, 130.214.79.11
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Networking:686
Article PK: 1132105


Sobari Tanuwijaya wrote in <45b18c10@solutions.advantagedatabase.com>:

> In my case it is 6420, I try the setting to test before I put it on
> the real server. sorry I don't get it, what do you mean with the
> ads.ini file are not being read? the application cannot find the
> ads.ini or the application cannot find the key located on the ads.ini?

both is possible

> You said that if it is 6097 the firewall should be configured to
> allow UDP and TCP, so if I just allow the TCP, it still will give the
> 6097 error code?

depends on the ADS version you use. TCP support was added in ADS 8.1
(and you also need a newer axcws32.dll for that).

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com