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.

DB on a NAS?

6 posts in Networking Last posting was on 2012-08-31 22:58:32.0Z
Ian Branch Posted on 2012-08-25 09:23:38.0Z
From: "Ian Branch" <branch_at_celestial_com_au>
Subject: DB on a NAS?
Newsgroups: Advantage.Networking
User-Agent: XanaNews/1.19.1.368 (x86; Portable ISpell)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 59.167.126.128
Message-ID: <5038999a$1@solutions.advantagedatabase.com>
Date: 25 Aug 2012 02:23:38 -0700
X-Trace: 25 Aug 2012 02:23:38 -0700, 59.167.126.128
Lines: 23
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Networking:1011
Article PK: 1132418

Hi Guys,

I have a data base with Data Dictionary on a Synology NAS, a DS211.

Running Win7 Ult. lasest ADS 10.

The PC path to the DD via the network is \\DISKSTATION\Disk
Station\DBWorkflow

The NAS is sitting on 192.168.0.6 via an ADSL router.

Using ARC I have tried the following and a few other permutations but
cannot access it. DBWorkflow=//192.168.0.6:6262/Disk
Station/DBWorkflow/DBWorkflow.add;D

Has anybody got experience with this configuration and can offer some
advice on connecting please?

Is this an ADS, Router or Win7 issue?

Regards & TIA,

Ian


Edgar Sherman Posted on 2012-08-27 14:23:44.0Z
Date: Mon, 27 Aug 2012 08:23:44 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: DB on a NAS?
References: <5038999a$1@solutions.advantagedatabase.com>
In-Reply-To: <5038999a$1@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.6.193.121
Message-ID: <503b82cd$1@solutions.advantagedatabase.com>
X-Trace: 27 Aug 2012 07:23:09 -0700, 10.6.193.121
Lines: 54
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Networking:1012
Article PK: 1103531

To use a NAS you need to use Server Side Aliases.

On your ADS server, create a server side alias that points to the NAS
(and folder of the data)

Then in your application connect to the alias.

http://devzone.advantagedatabase.com/dz/WebHelp/Advantage11/index.html?master_network_attached_storage_nas_devices.htm

For example:

Create an adsserver.ini in your error log path on the ADS server with
the following. Once created/saved, stop/start ADS
[ServerAliases]
DBWorkFlow=\\DISKSTATION\DiskStation\DBWorkflow

In the application connect to (substitute in your ADS server host name
here... Not the NAS)

\\win7ADSServerBox\DBWorkFlow\DBWorkflow.add

As a side note, I highly recommend against this setup. Be sure to read
the last two sections in that help file link very carefully.
Performance and Data Integrity
Limitations

Edgar

On 8/25/2012 3:23 AM, Ian Branch wrote:
> Hi Guys,
>
> I have a data base with Data Dictionary on a Synology NAS, a DS211.
>
> Running Win7 Ult. lasest ADS 10.
>
> The PC path to the DD via the network is \\DISKSTATION\Disk
> Station\DBWorkflow
>
> The NAS is sitting on 192.168.0.6 via an ADSL router.
>
> Using ARC I have tried the following and a few other permutations but
> cannot access it. DBWorkflow=//192.168.0.6:6262/Disk
> Station/DBWorkflow/DBWorkflow.add;D
>
> Has anybody got experience with this configuration and can offer some
> advice on connecting please?
>
> Is this an ADS, Router or Win7 issue?
>
> Regards & TIA,
>
> Ian
>


Ian Branch Posted on 2012-08-31 08:09:38.0Z
From: "Ian Branch" <branch_at_celestial_com_au>
Subject: Re: DB on a NAS?
Newsgroups: Advantage.Networking
References: <5038999a$1@solutions.advantagedatabase.com> <503b82cd$1@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.368 (x86; Portable ISpell)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 59.167.126.128
Message-ID: <50407142@solutions.advantagedatabase.com>
Date: 31 Aug 2012 01:09:38 -0700
X-Trace: 31 Aug 2012 01:09:38 -0700, 59.167.126.128
Lines: 72
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Networking:1015
Article PK: 1103547

Thanks Edgar,

Cautions noted.

So, having implemented the adsserver.ini,
DBWorkflow=\\DISKSTATION\Disk Station\DBWorkflow, which resides in c:\.

And using \\127.0.0.1:6262\DBWorkflow\DBWorkflow.add I get a 5004
error but the DBWorkflow.add file is definately there and ignorerights
is definately selected.

Regards,

Ian

Edgar Sherman wrote:

> To use a NAS you need to use Server Side Aliases.
>
> On your ADS server, create a server side alias that points to the NAS
> (and folder of the data)
>
> Then in your application connect to the alias.
>
>
http://devzone.advantagedatabase.com/dz/WebHelp/Advantage11/index.html?master_network_attached_storage_nas_devices.htm
>
> For example:
>
> Create an adsserver.ini in your error log path on the ADS server with
> the following. Once created/saved, stop/start ADS [ServerAliases]
> DBWorkFlow=\\DISKSTATION\DiskStation\DBWorkflow
>
> In the application connect to (substitute in your ADS server host
> name here... Not the NAS)
>
> \\win7ADSServerBox\DBWorkFlow\DBWorkflow.add
>
> As a side note, I highly recommend against this setup. Be sure to
> read the last two sections in that help file link very carefully.
> Performance and Data Integrity Limitations
>
> Edgar
>
>
> On 8/25/2012 3:23 AM, Ian Branch wrote:
> > Hi Guys,
> >
> > I have a data base with Data Dictionary on a Synology NAS, a DS211.
> >
> > Running Win7 Ult. lasest ADS 10.
> >
> > The PC path to the DD via the network is \\DISKSTATION\Disk
> > Station\DBWorkflow
> >
> > The NAS is sitting on 192.168.0.6 via an ADSL router.
> >
> > Using ARC I have tried the following and a few other permutations
> > but cannot access it. DBWorkflow=//192.168.0.6:6262/Disk
> > Station/DBWorkflow/DBWorkflow.add;D
> >
> > Has anybody got experience with this configuration and can offer
> > some advice on connecting please?
> >
> > Is this an ADS, Router or Win7 issue?
> >
> > Regards & TIA,
> >
> > Ian
> >


Edgar Sherman Posted on 2012-08-31 18:00:01.0Z
Date: Fri, 31 Aug 2012 12:00:01 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: DB on a NAS?
References: <5038999a$1@solutions.advantagedatabase.com> <503b82cd$1@solutions.advantagedatabase.com> <50407142@solutions.advantagedatabase.com>
In-Reply-To: <50407142@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.6.193.121
Message-ID: <5040fb72$1@solutions.advantagedatabase.com>
X-Trace: 31 Aug 2012 10:59:14 -0700, 10.6.193.121
Lines: 82
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Networking:1017
Article PK: 1103543

If you just created the adsserver.ini restart the ADS server. It
determines existence on startup only, but notices changes dynamically.

Also, remember that by default the ADS server runs as the "System" user.
Be sure to change this to a user that can access the NAS. (System can
not access network resources as far as I know).

Edgar

On 8/31/2012 2:09 AM, Ian Branch wrote:
> Thanks Edgar,
>
> Cautions noted.
>
> So, having implemented the adsserver.ini,
> DBWorkflow=\\DISKSTATION\Disk Station\DBWorkflow, which resides in c:\.
>
> And using \\127.0.0.1:6262\DBWorkflow\DBWorkflow.add I get a 5004
> error but the DBWorkflow.add file is definately there and ignorerights
> is definately selected.
>
> Regards,
>
> Ian
>
>
>
> Edgar Sherman wrote:
>
>> To use a NAS you need to use Server Side Aliases.
>>
>> On your ADS server, create a server side alias that points to the NAS
>> (and folder of the data)
>>
>> Then in your application connect to the alias.
>>
>>
> http://devzone.advantagedatabase.com/dz/WebHelp/Advantage11/index.html?master_network_attached_storage_nas_devices.htm
>>
>> For example:
>>
>> Create an adsserver.ini in your error log path on the ADS server with
>> the following. Once created/saved, stop/start ADS [ServerAliases]
>> DBWorkFlow=\\DISKSTATION\DiskStation\DBWorkflow
>>
>> In the application connect to (substitute in your ADS server host
>> name here... Not the NAS)
>>
>> \\win7ADSServerBox\DBWorkFlow\DBWorkflow.add
>>
>> As a side note, I highly recommend against this setup. Be sure to
>> read the last two sections in that help file link very carefully.
>> Performance and Data Integrity Limitations
>>
>> Edgar
>>
>>
>> On 8/25/2012 3:23 AM, Ian Branch wrote:
>>> Hi Guys,
>>>
>>> I have a data base with Data Dictionary on a Synology NAS, a DS211.
>>>
>>> Running Win7 Ult. lasest ADS 10.
>>>
>>> The PC path to the DD via the network is \\DISKSTATION\Disk
>>> Station\DBWorkflow
>>>
>>> The NAS is sitting on 192.168.0.6 via an ADSL router.
>>>
>>> Using ARC I have tried the following and a few other permutations
>>> but cannot access it. DBWorkflow=//192.168.0.6:6262/Disk
>>> Station/DBWorkflow/DBWorkflow.add;D
>>>
>>> Has anybody got experience with this configuration and can offer
>>> some advice on connecting please?
>>>
>>> Is this an ADS, Router or Win7 issue?
>>>
>>> Regards & TIA,
>>>
>>> Ian
>>>


Ian Branch Posted on 2012-08-31 21:16:22.0Z
From: "Ian Branch" <branch_at_celestial_com_au>
Subject: Re: DB on a NAS?
Newsgroups: Advantage.Networking
References: <5038999a$1@solutions.advantagedatabase.com> <503b82cd$1@solutions.advantagedatabase.com> <50407142@solutions.advantagedatabase.com> <5040fb72$1@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.368 (x86; Portable ISpell)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 59.167.126.128
Message-ID: <504129a6@solutions.advantagedatabase.com>
Date: 31 Aug 2012 14:16:22 -0700
X-Trace: 31 Aug 2012 14:16:22 -0700, 59.167.126.128
Lines: 20
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Networking:1018
Article PK: 1103546

Hi Edgar,

Thanks again.

Edgar Sherman wrote:

> If you just created the adsserver.ini restart the ADS server. It
> determines existence on startup only, but notices changes dynamically.
>

Did/Done

> Also, remember that by default the ADS server runs as the "System"
> user. Be sure to change this to a user that can access the NAS.
> (System can not access network resources as far as I know).
>
No I didn't realize that. Where/how do I change it please?

Regards,

Ian


Edgar Sherman Posted on 2012-08-31 22:58:32.0Z
Date: Fri, 31 Aug 2012 16:58:32 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: DB on a NAS?
References: <5038999a$1@solutions.advantagedatabase.com> <503b82cd$1@solutions.advantagedatabase.com> <50407142@solutions.advantagedatabase.com> <5040fb72$1@solutions.advantagedatabase.com> <504129a6@solutions.advantagedatabase.com>
In-Reply-To: <504129a6@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.6.193.121
Message-ID: <50414168$1@solutions.advantagedatabase.com>
X-Trace: 31 Aug 2012 15:57:44 -0700, 10.6.193.121
Lines: 30
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Networking:1019
Article PK: 1103551

You can change the the user by going to the services in windows. Find
Advantage and get to the properties.
Click the Log On tab.
Change to a user that has access rights.

Edgar

On 8/31/2012 3:16 PM, Ian Branch wrote:
> Hi Edgar,
>
> Thanks again.
>
> Edgar Sherman wrote:
>
>> If you just created the adsserver.ini restart the ADS server. It
>> determines existence on startup only, but notices changes dynamically.
>>
> Did/Done
>
>> Also, remember that by default the ADS server runs as the "System"
>> user. Be sure to change this to a user that can access the NAS.
>> (System can not access network resources as far as I know).
>>
> No I didn't realize that. Where/how do I change it please?
>
> Regards,
>
> Ian
>