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.

configuring datastore - AGDB

3 posts in General Discussion Last posting was on 2005-03-14 20:04:54.0Z
abbey Posted on 2005-03-13 20:50:16.0Z
From: abbey <a_adeyeye@yahoo.co.uk>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: configuring datastore - AGDB
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 62.173.81.130
Message-ID: <4234a784@forums-2-dub>
X-Original-Trace: 13 Mar 2005 12:50:12 -0800, 62.173.81.130
Lines: 8
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Mar 2005 12:50:13 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Mar 2005 12:50:16 -0800
X-Trace: forums-1-dub 1110747016 10.22.108.75 (13 Mar 2005 12:50:16 -0800)
X-Original-Trace: 13 Mar 2005 12:50:16 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:291
Article PK: 17641

Hello everyone,
I was wondering if it is possible to configure the MBA server to use a
database other than AGDB as its datastore, for example a new ASA
database that I've created or a new database on Oracle. I've read the
MBiz admin guide and it describes a way to configure the server to use
AGDB located on another server but nothing more.
Thanks for your time,
Abbey.


Chris Grim Posted on 2005-03-14 02:52:33.0Z
User-Agent: Microsoft-Entourage/11.1.0.040913
Subject: Re: configuring datastore - AGDB
From: Chris Grim <chrisgrim@hotmail.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
Message-ID: <BE5A3C6A.408%chrisgrim@hotmail.com>
References: <4234a784@forums-2-dub>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Original-NNTP-Posting-Host: adsl-63-200-37-206.dsl.snfc21.pacbell.net
X-Original-Trace: 13 Mar 2005 18:52:30 -0800, adsl-63-200-37-206.dsl.snfc21.pacbell.net
Lines: 31
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Mar 2005 18:52:31 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Mar 2005 18:52:33 -0800
X-Trace: forums-1-dub 1110768753 10.22.108.75 (13 Mar 2005 18:52:33 -0800)
X-Original-Trace: 13 Mar 2005 18:52:33 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:294
Article PK: 17639

Abbey,

It should be possible. You would have to do a little hacking, but if you
are experienced with ASA, it shouldn't be too daunting. This isn't
comprehensive, but it should get you started:

1. most of the settings for what database the M-Business Anywhere server
connects to can be found in \avantgoserver\conf\defaults. Take a look for
the datastore settings.

2. Before those settings will help you much, you'll need to set up the
database with the tables and users that M-Biz expects. Take a look at the
dbsetup script in that same directory. You should be able to figure out how
to get this script to point to your database and initialize it for use as an
M-Biz datastore.

Chris...

On 3/13/05 12:50 PM, in article 4234a784@forums-2-dub, "abbey"

<a_adeyeye@yahoo.co.uk> wrote:

> Hello everyone,
> I was wondering if it is possible to configure the MBA server to use a
> database other than AGDB as its datastore, for example a new ASA
> database that I've created or a new database on Oracle. I've read the
> MBiz admin guide and it describes a way to configure the server to use
> AGDB located on another server but nothing more.
> Thanks for your time,
> Abbey.


Enrico Pallazzo Posted on 2005-03-14 20:04:54.0Z
From: "Enrico Pallazzo" <nospam@nospam.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <4234a784@forums-2-dub> <BE5A3C6A.408%chrisgrim@hotmail.com>
Subject: Re: configuring datastore - AGDB
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vpn-dub-159.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-159.sybase.com
Message-ID: <4235ee66$1@forums-1-dub>
Date: 14 Mar 2005 12:04:54 -0800
X-Trace: forums-1-dub 1110830694 10.22.120.159 (14 Mar 2005 12:04:54 -0800)
X-Original-Trace: 14 Mar 2005 12:04:54 -0800, vpn-dub-159.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:297
Article PK: 17643

This is not correct. MBA uses ASA as an embedded datastore. You may be able
to get it working with a different version of ASA but it probably be buggy.
There is no chance it will work with oracle.

"Chris Grim" <chrisgrim@hotmail.com> wrote in message
news:BE5A3C6A.408%chrisgrim@hotmail.com...
> Abbey,
>
> It should be possible. You would have to do a little hacking, but if you
> are experienced with ASA, it shouldn't be too daunting. This isn't
> comprehensive, but it should get you started:
>
> 1. most of the settings for what database the M-Business Anywhere server
> connects to can be found in \avantgoserver\conf\defaults. Take a look for
> the datastore settings.
>
> 2. Before those settings will help you much, you'll need to set up the
> database with the tables and users that M-Biz expects. Take a look at the
> dbsetup script in that same directory. You should be able to figure out
> how
> to get this script to point to your database and initialize it for use as
> an
> M-Biz datastore.
>
> Chris...
>
> On 3/13/05 12:50 PM, in article 4234a784@forums-2-dub, "abbey"
> <a_adeyeye@yahoo.co.uk> wrote:
>
>> Hello everyone,
>> I was wondering if it is possible to configure the MBA server to use a
>> database other than AGDB as its datastore, for example a new ASA
>> database that I've created or a new database on Oracle. I've read the
>> MBiz admin guide and it describes a way to configure the server to use
>> AGDB located on another server but nothing more.
>> Thanks for your time,
>> Abbey.
>
>