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.

any special requirement for server side alias?

4 posts in Networking Last posting was on 2007-04-23 05:12:51.0Z
Sobari Tanuwijaya Posted on 2007-04-21 16:05:49.0Z
Date: Sat, 21 Apr 2007 23:05:49 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: any special requirement for server side alias?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.24.53
Message-ID: <462a3605@solutions.advantagedatabase.com>
X-Trace: 21 Apr 2007 10:04:21 -0700, 125.163.24.53
Lines: 16
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.24.53
Xref: solutions.advantagedatabase.com Advantage.Networking:698
Article PK: 1132118

Hi,
Just trying the server side alias, and several things come up:
1. I can connect to the alias specified on the AdsServer.ini if
I connect it from the same computer with the ads server, while
when I tried from another computer it always give me 6420 error
code, after a long wait (around 2 minutes or so).
I check the connection using the ARC ver 8.1 with the ignoreright
security mode.
2. Can I connect to the server using server side alias using the
client with older version ( for. e.g 7.1)?
3. Will the existence of ads.ini on the client give any effect for
the successfulness of connection?
4. Is there any port should be keep open to make this happen?
Thanks in advance.

-- Tanu --


Rodd Graham Posted on 2007-04-21 17:15:55.0Z
Date: Sat, 21 Apr 2007 17:15:55 +0000 (UTC)
Message-ID: <6c56a92229f068c95225f2200293@devzone.advantagedatabase.com>
From: Rodd Graham <rgraham@grahamautomation.com>
Subject: Re: any special requirement for server side alias?
Newsgroups: Advantage.Networking
References: <462a3605@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1046.1
NNTP-Posting-Host: 66.148.136.248
X-Trace: 21 Apr 2007 11:11:18 -0700, 66.148.136.248
Lines: 51
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!66.148.136.248
Xref: solutions.advantagedatabase.com Advantage.Networking:699
Article PK: 1132116

Hello Sobari,

Server side aliases don't eliminate the need for server discovery.

Assuming a connect path of:

\\Server\Share\Path\File

"Server" must still resolve on the client to the actual server that is hosting
ADS. If "Server" is not the native network name, you will need to use a
custom DNS (or WINS) entry to resolve it OR custom entries in the client
side ADS.INI.

The server side alias causes ADS to remap the "Share" portion of the connect
path only. Without a server side alias, ADS defaults to mapping the "Share"
portion to the local file system using the current server side Windows shares.
Hence, server side aliases are an override of the server side Windows shares
lookup for specific share names.

I do not know if server side aliases work with older clients. However, since
they should be transparent to the client, I would expect them to.

Of course, you cannot block any ports that ADS uses. You can configure the
ADS ports (LAN, AIS) on the server side. Default configuration is LAN=6262,
AIS=disabled.

Finally, if using semaphore files, the LAN client will require file system
access to the semaphore path as configured on the ADS server. Not sure if
AIS uses semaphore files or not.

Hope this helps,

Rodd

> Hi,
> Just trying the server side alias, and several things come up:
> 1. I can connect to the alias specified on the AdsServer.ini if
> I connect it from the same computer with the ads server, while
> when I tried from another computer it always give me 6420 error
> code, after a long wait (around 2 minutes or so).
> I check the connection using the ARC ver 8.1 with the ignoreright
> security mode.
> 2. Can I connect to the server using server side alias using the
> client with older version ( for. e.g 7.1)?
> 3. Will the existence of ads.ini on the client give any effect for
> the successfulness of connection?
> 4. Is there any port should be keep open to make this happen?
> Thanks in advance.
>


Sobari Tanuwijaya Posted on 2007-04-22 16:37:19.0Z
Date: Sun, 22 Apr 2007 23:37:19 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: any special requirement for server side alias?
References: <462a3605@solutions.advantagedatabase.com> <6c56a92229f068c95225f2200293@devzone.advantagedatabase.com>
In-Reply-To: <6c56a92229f068c95225f2200293@devzone.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.19.75
Message-ID: <462b8ee9@solutions.advantagedatabase.com>
X-Trace: 22 Apr 2007 10:35:53 -0700, 125.163.19.75
Lines: 73
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.19.75
Xref: solutions.advantagedatabase.com Advantage.Networking:700
Article PK: 1132119

Hi Rodd,
Thank for the reply.

If you mean that can I access the server using the name specified, the
answer is yes.
I can connect to it for e.g. from typing the server name from start->run

I have done several trial, and one of it is disabled the loopback
adapter and now the error is 7078, even when I try to connect from
the same computer where the ads installed. I have make sure the username
and password is correct but the same error still coming up.
The question is:
* Is the ADS server tied to certain IP address?
In the server computer there are several NIC with different IP
addresses, will this situation raise a problem for connecting to
ADS?
* Why now I cannot connect to the database even if I try to connect from
the same computer with the server. ( If I access it using the drive
and folder name, everything is OK).

--

Rodd Graham wrote:
> Hello Sobari,
>
> Server side aliases don't eliminate the need for server discovery.
>
> Assuming a connect path of:
>
> \\Server\Share\Path\File
>
> "Server" must still resolve on the client to the actual server that is
> hosting ADS. If "Server" is not the native network name, you will need
> to use a custom DNS (or WINS) entry to resolve it OR custom entries in
> the client side ADS.INI.
>
> The server side alias causes ADS to remap the "Share" portion of the
> connect path only. Without a server side alias, ADS defaults to mapping
> the "Share" portion to the local file system using the current server
> side Windows shares. Hence, server side aliases are an override of the
> server side Windows shares lookup for specific share names.
>
> I do not know if server side aliases work with older clients. However,
> since they should be transparent to the client, I would expect them to.
>
> Of course, you cannot block any ports that ADS uses. You can configure
> the ADS ports (LAN, AIS) on the server side. Default configuration is
> LAN=6262, AIS=disabled.
>
> Finally, if using semaphore files, the LAN client will require file
> system access to the semaphore path as configured on the ADS server.
> Not sure if AIS uses semaphore files or not.
>
> Hope this helps,
>
> Rodd
>
>> Hi,
>> Just trying the server side alias, and several things come up:
>> 1. I can connect to the alias specified on the AdsServer.ini if
>> I connect it from the same computer with the ads server, while
>> when I tried from another computer it always give me 6420 error
>> code, after a long wait (around 2 minutes or so).
>> I check the connection using the ARC ver 8.1 with the ignoreright
>> security mode.
>> 2. Can I connect to the server using server side alias using the
>> client with older version ( for. e.g 7.1)?
>> 3. Will the existence of ads.ini on the client give any effect for
>> the successfulness of connection?
>> 4. Is there any port should be keep open to make this happen?
>> Thanks in advance.
>>
>
>


Rodd Graham Posted on 2007-04-23 05:12:51.0Z
Date: Mon, 23 Apr 2007 05:12:51 +0000 (UTC)
Message-ID: <6c56a92229f8e8c9535344484ba2@devzone.advantagedatabase.com>
From: Rodd Graham <rgraham@grahamautomation.com>
Subject: Re: any special requirement for server side alias?
Newsgroups: Advantage.Networking
References: <462b8ee9@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1046.1
NNTP-Posting-Host: 66.148.136.248
X-Trace: 22 Apr 2007 23:08:14 -0700, 66.148.136.248
Lines: 49
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!66.148.136.248
Xref: solutions.advantagedatabase.com Advantage.Networking:701
Article PK: 1132122

Hello Sobari,

> * Is the ADS server tied to certain IP address?

It does not appear to be, but ADS support might know more specifically.
The output from NetStat -na:

TCP 0.0.0.0:6262 0.0.0.0:0 LISTENING

appears to be listening on all interfaces.

> * Why now I cannot connect to the database even if I try to connect
> from the same computer with the server. ( If I access it using the drive
> and folder name, everything is OK).

Should probably provide information about how you are trying to access (ie.
ADS Version, Windows Version, Network topology, ADS Configuration, Application,
Driver interface(s), Connection strings, etc.). It is hard to determine
where the problem lies without the details.

What does your server side alias entry look like?
Can you connect through UNC without the alias?
Does ADS show the database open by any client?
Are your network interfaces firewalled?

Rodd

> Hi Rodd,
> Thank for the reply.
> If you mean that can I access the server using the name specified, the
> answer is yes.
> I can connect to it for e.g. from typing the server name from
> start->run
> I have done several trial, and one of it is disabled the loopback
> adapter and now the error is 7078, even when I try to connect from
> the same computer where the ads installed. I have make sure the
> username
> and password is correct but the same error still coming up.
> The question is:
> * Is the ADS server tied to certain IP address?
> In the server computer there are several NIC with different IP
> addresses, will this situation raise a problem for connecting to
> ADS?
> * Why now I cannot connect to the database even if I try to connect
> from
> the same computer with the server. ( If I access it using the drive
> and folder name, everything is OK).