Hi,

Is it possible to use server-side alias in xbase++ ?

I have set following adsserver.ini
[ServerAliases]
hotelier=D:\Release\CasinoC6\

and put it in ADS error folder D:\ADS\AdsError directory.

Then i tried to access data from the client through Data
Architect->Tools->Remote Server Info by giving
\\hotelier\casinoc6.add. then it shows Username and password. When
giving username and password, shows 6420 error.

Also given IGNORE_RIGHTS

What could be the reason ?

Regards
Kiron

Hi,

Althouigh I don't use server-side ailiases with ADS I was reading
though tye ADS documentation in advantage.chm and believe that you are
referencing it incorrectly in your client.  Where you have:
\\hotelier\casinoc6.add you are not telling the client what server...

Here is the the extract from the ADS 11.1 help file...

Usage

To use a server-side alias, simply reference the alias name where you
would normally reference a file share in your connection path.

For example, if your connection string would normally be
\\myserver\myshare\mydatadir, to use the "alias_test" alias, you would
change your connection path to \\myserver\alias_test\mydatadir.

The "share" name in your connection path will be replaced with
whatever path you provided for the alias in the adsserver.ini file.

Hope this helps... Jonathan






On Mon, 09 Jan 2017 18:23:21 +0530, Jacob John wrote:

>Hi,
>
>Is it possible to use server-side alias in xbase++ ?
>
>I have set following adsserver.ini
>[ServerAliases]
>hotelier=D:\Release\CasinoC6\
>
>and put it in ADS error folder D:\ADS\AdsError directory.
>
>Then i tried to access data from the client through Data
>Architect->Tools->Remote Server Info by giving
>\\hotelier\casinoc6.add. then it shows Username and password. When
>giving username and password, shows 6420 error.
>
>Also given IGNORE_RIGHTS
>
>What could be the reason ?
>
>Regards
>Kiron

Hi Jonathan,

I tried that. But getting same message. I was trying to avoid windows
share due to security issues. Because the Advantage help says that

"Server-side aliases not only hide the path to your data, but they
also allow you to remove all Windows shares and still connect to your
Advantage data. This functionality provides increased security and
convenience"

Pascal Bovin confirms that server side alias will work with ADSDBE, in
his post in Advantage.XBase++ news group on 01/03/2012

Regards
Kiron

On Mon, 09 Jan 2017 15:14:39 -0700, Jonathan Leeming wrote:

>Hi,
>
>Althouigh I don't use server-side ailiases with ADS I was reading
>though tye ADS documentation in advantage.chm and believe that you are
>referencing it incorrectly in your client.  Where you have:
>\\hotelier\casinoc6.add you are not telling the client what server...
>
>Here is the the extract from the ADS 11.1 help file...
>
>Usage
>
>To use a server-side alias, simply reference the alias name where you
>would normally reference a file share in your connection path.
>
>For example, if your connection string would normally be
>\\myserver\myshare\mydatadir, to use the "alias_test" alias, you would
>change your connection path to \\myserver\alias_test\mydatadir.
>
>The "share" name in your connection path will be replaced with
>whatever path you provided for the alias in the adsserver.ini file.
>
>Hope this helps... Jonathan
>
>
>
>
>
>
>On Mon, 09 Jan 2017 18:23:21 +0530, Jacob John wrote:
>
>>Hi,
>>
>>Is it possible to use server-side alias in xbase++ ?
>>
>>I have set following adsserver.ini
>>[ServerAliases]
>>hotelier=D:\Release\CasinoC6\
>>
>>and put it in ADS error folder D:\ADS\AdsError directory.
>>
>>Then i tried to access data from the client through Data
>>Architect->Tools->Remote Server Info by giving
>>\\hotelier\casinoc6.add. then it shows Username and password. When
>>giving username and password, shows 6420 error.
>>
>>Also given IGNORE_RIGHTS
>>
>>What could be the reason ?
>>
>>Regards
>>Kiron

Hi,

Solved the problem. If I understanding correct following is the way

My adsserver.ini is 
[ServerAliases]
hotelier=D:\VER.15.30\CASINOC6


I can access CASINOC6.ADD in D:\VER.15.30\CASINOC6 through the
following connection string.

"\\MyDBServer\hotelier\CASINOC6.ADD" where MyDBServer is the system
where ADS is installed.
ie
AdsServer+ServerSideAlias+Data Dictionary

ServerSideAlias "hotelier" is automatically resolved by the ADS Server

Before opening the tables you should give 
SET RIGHTS CHECKING OFF

Regards
Kiron


On Tue, 10 Jan 2017 11:32:54 +0530, Jacob John wrote:

>Hi Jonathan,
>
>I tried that. But getting same message. I was trying to avoid windows
>share due to security issues. Because the Advantage help says that
>
>"Server-side aliases not only hide the path to your data, but they
>also allow you to remove all Windows shares and still connect to your
>Advantage data. This functionality provides increased security and
>convenience"
>
>Pascal Bovin confirms that server side alias will work with ADSDBE, in
>his post in Advantage.XBase++ news group on 01/03/2012
>
>Regards
>Kiron
>
>On Mon, 09 Jan 2017 15:14:39 -0700, Jonathan Leeming wrote:
>
>>Hi,
>>
>>Althouigh I don't use server-side ailiases with ADS I was reading
>>though tye ADS documentation in advantage.chm and believe that you are
>>referencing it incorrectly in your client.  Where you have:
>>\\hotelier\casinoc6.add you are not telling the client what server...
>>
>>Here is the the extract from the ADS 11.1 help file...
>>
>>Usage
>>
>>To use a server-side alias, simply reference the alias name where you
>>would normally reference a file share in your connection path.
>>
>>For example, if your connection string would normally be
>>\\myserver\myshare\mydatadir, to use the "alias_test" alias, you would
>>change your connection path to \\myserver\alias_test\mydatadir.
>>
>>The "share" name in your connection path will be replaced with
>>whatever path you provided for the alias in the adsserver.ini file.
>>
>>Hope this helps... Jonathan
>>
>>
>>
>>
>>
>>
>>On Mon, 09 Jan 2017 18:23:21 +0530, Jacob John wrote:
>>
>>>Hi,
>>>
>>>Is it possible to use server-side alias in xbase++ ?
>>>
>>>I have set following adsserver.ini
>>>[ServerAliases]
>>>hotelier=D:\Release\CasinoC6\
>>>
>>>and put it in ADS error folder D:\ADS\AdsError directory.
>>>
>>>Then i tried to access data from the client through Data
>>>Architect->Tools->Remote Server Info by giving
>>>\\hotelier\casinoc6.add. then it shows Username and password. When
>>>giving username and password, shows 6420 error.
>>>
>>>Also given IGNORE_RIGHTS
>>>
>>>What could be the reason ?
>>>
>>>Regards
>>>Kiron