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.

Licensing of a proxy database

8 posts in General Discussion Last posting was on 2004-12-17 10:42:14.0Z
"Chris Werner" <cw[please_no_spam] Posted on 2004-12-09 12:00:41.0Z
From: "Chris Werner" <cw[please_no_spam]@f-s.de>
Newsgroups: ianywhere.public.general
Subject: Licensing of a proxy database
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.8.156.42
X-Original-NNTP-Posting-Host: 62.8.156.42
Message-ID: <41b83e69@forums-1-dub>
Date: 9 Dec 2004 04:00:41 -0800
X-Trace: forums-1-dub 1102593641 62.8.156.42 (9 Dec 2004 04:00:41 -0800)
X-Original-Trace: 9 Dec 2004 04:00:41 -0800, 62.8.156.42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3951
Article PK: 7842

Hi all,

I discuss with a customer solutions to make
an oracle database accessible on mobile
devices using pocketbuilder and ASA as
local database and server database containing
proxy tables which points to tables in the oracle
database. The customer claims that he would
need 2 licenses for every mobile device, one
local license for the device and one connection
license for the proxy database. Is that right?

TIA

Chris Werner


Robert Waywell Posted on 2004-12-09 13:56:48.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <41b83e69@forums-1-dub>
Subject: Re: Licensing of a proxy database
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <41b8599c$1@forums-2-dub>
X-Original-Trace: 9 Dec 2004 05:56:44 -0800, rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Dec 2004 05:56:45 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Dec 2004 05:56:48 -0800
X-Trace: forums-1-dub 1102600608 10.22.108.75 (9 Dec 2004 05:56:48 -0800)
X-Original-Trace: 9 Dec 2004 05:56:48 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3952
Article PK: 7843

Physically, with a proxy table connection from an ASA database to an Oracle
database, the ASA database is just a client application. The licensing for
that client connection will depend on Oracle's requirements in this case, so
you would need to check with them.

Having said that, is there a particular reason why you would want to
implement a middle tier ASA consolidated database as opposed to having the
handhelds synchronize directly against Oracle using MobiLink?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
news:41b83e69@forums-1-dub...
> Hi all,
>
> I discuss with a customer solutions to make
> an oracle database accessible on mobile
> devices using pocketbuilder and ASA as
> local database and server database containing
> proxy tables which points to tables in the oracle
> database. The customer claims that he would
> need 2 licenses for every mobile device, one
> local license for the device and one connection
> license for the proxy database. Is that right?
>
> TIA
>
> Chris Werner
>
>


"Chris Werner" <cw[please_no_spam] Posted on 2004-12-09 16:35:48.0Z
From: "Chris Werner" <cw[please_no_spam]@f-s.de>
Newsgroups: ianywhere.public.general
References: <41b83e69@forums-1-dub> <41b8599c$1@forums-2-dub>
Subject: Re: Licensing of a proxy database
Lines: 77
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 62.8.156.42
Message-ID: <41b87edd@forums-2-dub>
X-Original-Trace: 9 Dec 2004 08:35:41 -0800, 62.8.156.42
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Dec 2004 08:35:43 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Dec 2004 08:35:48 -0800
X-Trace: forums-1-dub 1102610148 10.22.108.75 (9 Dec 2004 08:35:48 -0800)
X-Original-Trace: 9 Dec 2004 08:35:48 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3956
Article PK: 7847

Thank you very much for your help.

I don't want synchronize using mobilink but
use an online connection to the enterprise
database which is oracle. So my pocketbuilder
application uses an ASA client to connect
(via WAN) to the ASA server database which
contains proxy tables to get access to the oracle
tables. This should be possible if I understand
the concept of proxy tables right?

Thanks again

Chris Werner


"Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
news:41b8599c$1@forums-2-dub...

> Physically, with a proxy table connection from an ASA database to an
Oracle
> database, the ASA database is just a client application. The licensing for
> that client connection will depend on Oracle's requirements in this case,
so
> you would need to check with them.
>
> Having said that, is there a particular reason why you would want to
> implement a middle tier ASA consolidated database as opposed to having the
> handhelds synchronize directly against Oracle using MobiLink?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>

http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
> news:41b83e69@forums-1-dub...
> > Hi all,
> >
> > I discuss with a customer solutions to make
> > an oracle database accessible on mobile
> > devices using pocketbuilder and ASA as
> > local database and server database containing
> > proxy tables which points to tables in the oracle
> > database. The customer claims that he would
> > need 2 licenses for every mobile device, one
> > local license for the device and one connection
> > license for the proxy database. Is that right?
> >
> > TIA
> >
> > Chris Werner
> >
> >
>
>


Robert Waywell Posted on 2004-12-13 15:14:46.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <41b83e69@forums-1-dub> <41b8599c$1@forums-2-dub> <41b87edd@forums-2-dub>
Subject: Re: Licensing of a proxy database
Lines: 111
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <41bdb1e6$1@forums-1-dub>
Date: 13 Dec 2004 07:14:46 -0800
X-Trace: forums-1-dub 1102950886 10.25.98.201 (13 Dec 2004 07:14:46 -0800)
X-Original-Trace: 13 Dec 2004 07:14:46 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3972
Article PK: 7867

Yes your proposed architecture is physically possible, although it does
depend on the stability of your connection. In a controlled environment
using a wireless LAN connection, the connection is quite probably reliable.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
news:41b87edd@forums-2-dub...
> Thank you very much for your help.
>
> I don't want synchronize using mobilink but
> use an online connection to the enterprise
> database which is oracle. So my pocketbuilder
> application uses an ASA client to connect
> (via WAN) to the ASA server database which
> contains proxy tables to get access to the oracle
> tables. This should be possible if I understand
> the concept of proxy tables right?
>
> Thanks again
>
> Chris Werner
>
>
> "Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
> news:41b8599c$1@forums-2-dub...
> > Physically, with a proxy table connection from an ASA database to an
> Oracle
> > database, the ASA database is just a client application. The licensing
for
> > that client connection will depend on Oracle's requirements in this
case,
> so
> > you would need to check with them.
> >
> > Having said that, is there a particular reason why you would want to
> > implement a middle tier ASA consolidated database as opposed to having
the
> > handhelds synchronize directly against Oracle using MobiLink?
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports:
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> ug
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
> > news:41b83e69@forums-1-dub...
> > > Hi all,
> > >
> > > I discuss with a customer solutions to make
> > > an oracle database accessible on mobile
> > > devices using pocketbuilder and ASA as
> > > local database and server database containing
> > > proxy tables which points to tables in the oracle
> > > database. The customer claims that he would
> > > need 2 licenses for every mobile device, one
> > > local license for the device and one connection
> > > license for the proxy database. Is that right?
> > >
> > > TIA
> > >
> > > Chris Werner
> > >
> > >
> >
> >
>
>


"Chris Werner" <cw[please_no_spam] Posted on 2004-12-16 10:57:04.0Z
From: "Chris Werner" <cw[please_no_spam]@f-s.de>
Newsgroups: ianywhere.public.general
References: <41b83e69@forums-1-dub> <41b8599c$1@forums-2-dub> <41b87edd@forums-2-dub> <41bdb1e6$1@forums-1-dub>
Subject: Re: Licensing of a proxy database
Lines: 133
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.8.156.42
X-Original-NNTP-Posting-Host: 62.8.156.42
Message-ID: <41c16a00$1@forums-1-dub>
Date: 16 Dec 2004 02:57:04 -0800
X-Trace: forums-1-dub 1103194624 62.8.156.42 (16 Dec 2004 02:57:04 -0800)
X-Original-Trace: 16 Dec 2004 02:57:04 -0800, 62.8.156.42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3977
Article PK: 7869

Thanks for your answer. One question comes
into my mind. The SQL dialect differs between
ASA and ORA (operators, functions, outer joins).
Can I use full ORA functionality with this
architecture? What dialect I have to use?

TIA

Chris Werner




"Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
news:41bdb1e6$1@forums-1-dub...

> Yes your proposed architecture is physically possible, although it does
> depend on the stability of your connection. In a controlled environment
> using a wireless LAN connection, the connection is quite probably
reliable.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>

http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
> news:41b87edd@forums-2-dub...
> > Thank you very much for your help.
> >
> > I don't want synchronize using mobilink but
> > use an online connection to the enterprise
> > database which is oracle. So my pocketbuilder
> > application uses an ASA client to connect
> > (via WAN) to the ASA server database which
> > contains proxy tables to get access to the oracle
> > tables. This should be possible if I understand
> > the concept of proxy tables right?
> >
> > Thanks again
> >
> > Chris Werner
> >
> >
> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
> > news:41b8599c$1@forums-2-dub...
> > > Physically, with a proxy table connection from an ASA database to an
> > Oracle
> > > database, the ASA database is just a client application. The licensing
> for
> > > that client connection will depend on Oracle's requirements in this
> case,
> > so
> > > you would need to check with them.
> > >
> > > Having said that, is there a particular reason why you would want to
> > > implement a middle tier ASA consolidated database as opposed to having
> the
> > > handhelds synchronize directly against Oracle using MobiLink?
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to all
> > >
> > > To Submit Bug Reports:
> > >
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> > ug
> > >
> > > SQL Anywhere Studio Supported Platforms and Support Status
> > > http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available through the
> > iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
> > > news:41b83e69@forums-1-dub...
> > > > Hi all,
> > > >
> > > > I discuss with a customer solutions to make
> > > > an oracle database accessible on mobile
> > > > devices using pocketbuilder and ASA as
> > > > local database and server database containing
> > > > proxy tables which points to tables in the oracle
> > > > database. The customer claims that he would
> > > > need 2 licenses for every mobile device, one
> > > > local license for the device and one connection
> > > > license for the proxy database. Is that right?
> > > >
> > > > TIA
> > > >
> > > > Chris Werner
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Breck Carter [TeamSybase] Posted on 2004-12-16 12:10:57.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Licensing of a proxy database
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <gos2s0lepebhbd2vjfh584gm9o1jppornc@4ax.com>
References: <41b83e69@forums-1-dub> <41b8599c$1@forums-2-dub> <41b87edd@forums-2-dub> <41bdb1e6$1@forums-1-dub> <41c16a00$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ip67-93-228-42.z228-93-67.customer.algx.net
X-Original-NNTP-Posting-Host: ip67-93-228-42.z228-93-67.customer.algx.net
Date: 16 Dec 2004 04:10:57 -0800
X-Trace: forums-1-dub 1103199057 67.93.228.42 (16 Dec 2004 04:10:57 -0800)
X-Original-Trace: 16 Dec 2004 04:10:57 -0800, ip67-93-228-42.z228-93-67.customer.algx.net
Lines: 168
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3978
Article PK: 7870

Proxy tables are *SQL Anywhere* tables, not Oracle tables, as far as
the syntax of SQL statements issued to the SQL Anywhere database is
concerned. For example, you will not be able to use the Oracle "(+)"
outer join operator in a WHERE clause (not that you would want to, but
that's not my point here :)

You can do *lots* of stuff with Oracle via proxy tables, and there are
workarounds for some of the issues; one popular trick is to create a
view on the Oracle side, since a proxy table can map to a view as well
as a table. The FORWARD TO statement is powerful as well, although I
haven't been able to get it to return a result set in any environment
except ISQL (gosh, that would be nice!)

For example, I use SQL Anywhere stored procedures to display the
Oracle catalog tables in HTML, whenever I visit a client using Oracle
(see http://www.risingroad.com/toolbox.html )... proxy tables are used
to suck the Oracle catalog into an environment where the SQL syntax
truly rocks! (with apologies to Oracle fans, it ranks well ahead of
DB2 in my opinion, but nowhere *near* SQL Anywhere in terms of
language features :)

Post new messages asking "How do I do <this thing> with Oracle proxy
tables?" and we'll try to answer.

Breck

On 16 Dec 2004 02:57:04 -0800, "Chris Werner"

<cw[please_no_spam]@f-s.de> wrote:

>Thanks for your answer. One question comes
>into my mind. The SQL dialect differs between
>ASA and ORA (operators, functions, outer joins).
>Can I use full ORA functionality with this
>architecture? What dialect I have to use?
>
>TIA
>
> Chris Werner
>
>
>
>
>"Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
>news:41bdb1e6$1@forums-1-dub...
>> Yes your proposed architecture is physically possible, although it does
>> depend on the stability of your connection. In a controlled environment
>> using a wireless LAN connection, the connection is quite probably
>reliable.
>>
>> --
>> -----------------------------------------------
>> Robert Waywell
>> Sybase Adaptive Server Anywhere Developer - Version 8
>> Sybase Certified Professional
>>
>> Sybase's iAnywhere Solutions
>>
>> Please respond ONLY to newsgroup
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports:
>>
>http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
>ug
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>>
>> Whitepapers, TechDocs, and bug fixes are all available through the
>iAnywhere
>> Developer Community at www.ianywhere.com/developer
>>
>> "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
>> news:41b87edd@forums-2-dub...
>> > Thank you very much for your help.
>> >
>> > I don't want synchronize using mobilink but
>> > use an online connection to the enterprise
>> > database which is oracle. So my pocketbuilder
>> > application uses an ASA client to connect
>> > (via WAN) to the ASA server database which
>> > contains proxy tables to get access to the oracle
>> > tables. This should be possible if I understand
>> > the concept of proxy tables right?
>> >
>> > Thanks again
>> >
>> > Chris Werner
>> >
>> >
>> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
>> > news:41b8599c$1@forums-2-dub...
>> > > Physically, with a proxy table connection from an ASA database to an
>> > Oracle
>> > > database, the ASA database is just a client application. The licensing
>> for
>> > > that client connection will depend on Oracle's requirements in this
>> case,
>> > so
>> > > you would need to check with them.
>> > >
>> > > Having said that, is there a particular reason why you would want to
>> > > implement a middle tier ASA consolidated database as opposed to having
>> the
>> > > handhelds synchronize directly against Oracle using MobiLink?
>> > >
>> > > --
>> > > -----------------------------------------------
>> > > Robert Waywell
>> > > Sybase Adaptive Server Anywhere Developer - Version 8
>> > > Sybase Certified Professional
>> > >
>> > > Sybase's iAnywhere Solutions
>> > >
>> > > Please respond ONLY to newsgroup
>> > >
>> > > EBF's and Patches: http://downloads.sybase.com
>> > > choose SQL Anywhere Studio >> change 'time frame' to all
>> > >
>> > > To Submit Bug Reports:
>> > >
>> >
>>
>http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
>> > ug
>> > >
>> > > SQL Anywhere Studio Supported Platforms and Support Status
>> > > http://my.sybase.com/detail?id=1002288
>> > >
>> > > Whitepapers, TechDocs, and bug fixes are all available through the
>> > iAnywhere
>> > > Developer Community at www.ianywhere.com/developer
>> > >
>> > > "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
>> > > news:41b83e69@forums-1-dub...
>> > > > Hi all,
>> > > >
>> > > > I discuss with a customer solutions to make
>> > > > an oracle database accessible on mobile
>> > > > devices using pocketbuilder and ASA as
>> > > > local database and server database containing
>> > > > proxy tables which points to tables in the oracle
>> > > > database. The customer claims that he would
>> > > > need 2 licenses for every mobile device, one
>> > > > local license for the device and one connection
>> > > > license for the proxy database. Is that right?
>> > > >
>> > > > TIA
>> > > >
>> > > > Chris Werner
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>>
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


"Chris Werner" <cw[please_no_spam] Posted on 2004-12-16 14:02:34.0Z
From: "Chris Werner" <cw[please_no_spam]@f-s.de>
Newsgroups: ianywhere.public.general
References: <41b83e69@forums-1-dub> <41b8599c$1@forums-2-dub> <41b87edd@forums-2-dub> <41bdb1e6$1@forums-1-dub> <41c16a00$1@forums-1-dub> <gos2s0lepebhbd2vjfh584gm9o1jppornc@4ax.com>
Subject: Re: Licensing of a proxy database
Lines: 201
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.8.156.42
X-Original-NNTP-Posting-Host: 62.8.156.42
Message-ID: <41c1957a$1@forums-1-dub>
Date: 16 Dec 2004 06:02:34 -0800
X-Trace: forums-1-dub 1103205754 62.8.156.42 (16 Dec 2004 06:02:34 -0800)
X-Original-Trace: 16 Dec 2004 06:02:34 -0800, 62.8.156.42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3982
Article PK: 7874

Hi Breck,

thank you very much for your detailed explanation and
right, nobody should want to use Oracles (+) operator
but sometimes - declared - it is comfortable short. (Don't
want to argue here.)

At the time being I have no question of the form "How
do I do ..." but I wonder how ASA maintains the
connections to Oracle? Is there something like a connection
cache or will ASA reconnect for every single statement?
That would'nt violate transaction processing and slow
down processing.

Regards

Chris Werner


"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> schrieb im
Newsbeitrag news:gos2s0lepebhbd2vjfh584gm9o1jppornc@4ax.com...

> Proxy tables are *SQL Anywhere* tables, not Oracle tables, as far as
> the syntax of SQL statements issued to the SQL Anywhere database is
> concerned. For example, you will not be able to use the Oracle "(+)"
> outer join operator in a WHERE clause (not that you would want to, but
> that's not my point here :)
>
> You can do *lots* of stuff with Oracle via proxy tables, and there are
> workarounds for some of the issues; one popular trick is to create a
> view on the Oracle side, since a proxy table can map to a view as well
> as a table. The FORWARD TO statement is powerful as well, although I
> haven't been able to get it to return a result set in any environment
> except ISQL (gosh, that would be nice!)
>
> For example, I use SQL Anywhere stored procedures to display the
> Oracle catalog tables in HTML, whenever I visit a client using Oracle
> (see http://www.risingroad.com/toolbox.html )... proxy tables are used
> to suck the Oracle catalog into an environment where the SQL syntax
> truly rocks! (with apologies to Oracle fans, it ranks well ahead of
> DB2 in my opinion, but nowhere *near* SQL Anywhere in terms of
> language features :)
>
> Post new messages asking "How do I do <this thing> with Oracle proxy
> tables?" and we'll try to answer.
>
> Breck
>
> On 16 Dec 2004 02:57:04 -0800, "Chris Werner"
> <cw[please_no_spam]@f-s.de> wrote:
>
> >Thanks for your answer. One question comes
> >into my mind. The SQL dialect differs between
> >ASA and ORA (operators, functions, outer joins).
> >Can I use full ORA functionality with this
> >architecture? What dialect I have to use?
> >
> >TIA
> >
> > Chris Werner
> >
> >
> >
> >
> >"Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
> >news:41bdb1e6$1@forums-1-dub...
> >> Yes your proposed architecture is physically possible, although it does
> >> depend on the stability of your connection. In a controlled environment
> >> using a wireless LAN connection, the connection is quite probably
> >reliable.
> >>
> >> --
> >> -----------------------------------------------
> >> Robert Waywell
> >> Sybase Adaptive Server Anywhere Developer - Version 8
> >> Sybase Certified Professional
> >>
> >> Sybase's iAnywhere Solutions
> >>
> >> Please respond ONLY to newsgroup
> >>
> >> EBF's and Patches: http://downloads.sybase.com
> >> choose SQL Anywhere Studio >> change 'time frame' to all
> >>
> >> To Submit Bug Reports:
> >>
>
>http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=
B
> >ug
> >>
> >> SQL Anywhere Studio Supported Platforms and Support Status
> >> http://my.sybase.com/detail?id=1002288
> >>
> >> Whitepapers, TechDocs, and bug fixes are all available through the
> >iAnywhere
> >> Developer Community at www.ianywhere.com/developer
> >>
> >> "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
> >> news:41b87edd@forums-2-dub...
> >> > Thank you very much for your help.
> >> >
> >> > I don't want synchronize using mobilink but
> >> > use an online connection to the enterprise
> >> > database which is oracle. So my pocketbuilder
> >> > application uses an ASA client to connect
> >> > (via WAN) to the ASA server database which
> >> > contains proxy tables to get access to the oracle
> >> > tables. This should be possible if I understand
> >> > the concept of proxy tables right?
> >> >
> >> > Thanks again
> >> >
> >> > Chris Werner
> >> >
> >> >
> >> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im
Newsbeitrag
> >> > news:41b8599c$1@forums-2-dub...
> >> > > Physically, with a proxy table connection from an ASA database to
an
> >> > Oracle
> >> > > database, the ASA database is just a client application. The
licensing
> >> for
> >> > > that client connection will depend on Oracle's requirements in this
> >> case,
> >> > so
> >> > > you would need to check with them.
> >> > >
> >> > > Having said that, is there a particular reason why you would want
to
> >> > > implement a middle tier ASA consolidated database as opposed to
having
> >> the
> >> > > handhelds synchronize directly against Oracle using MobiLink?
> >> > >
> >> > > --
> >> > > -----------------------------------------------
> >> > > Robert Waywell
> >> > > Sybase Adaptive Server Anywhere Developer - Version 8
> >> > > Sybase Certified Professional
> >> > >
> >> > > Sybase's iAnywhere Solutions
> >> > >
> >> > > Please respond ONLY to newsgroup
> >> > >
> >> > > EBF's and Patches: http://downloads.sybase.com
> >> > > choose SQL Anywhere Studio >> change 'time frame' to all
> >> > >
> >> > > To Submit Bug Reports:
> >> > >
> >> >
> >>
>
>http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=
B
> >> > ug
> >> > >
> >> > > SQL Anywhere Studio Supported Platforms and Support Status
> >> > > http://my.sybase.com/detail?id=1002288
> >> > >
> >> > > Whitepapers, TechDocs, and bug fixes are all available through the
> >> > iAnywhere
> >> > > Developer Community at www.ianywhere.com/developer
> >> > >
> >> > > "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
> >> > > news:41b83e69@forums-1-dub...
> >> > > > Hi all,
> >> > > >
> >> > > > I discuss with a customer solutions to make
> >> > > > an oracle database accessible on mobile
> >> > > > devices using pocketbuilder and ASA as
> >> > > > local database and server database containing
> >> > > > proxy tables which points to tables in the oracle
> >> > > > database. The customer claims that he would
> >> > > > need 2 licenses for every mobile device, one
> >> > > > local license for the device and one connection
> >> > > > license for the proxy database. Is that right?
> >> > > >
> >> > > > TIA
> >> > > >
> >> > > > Chris Werner
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Breck Carter [TeamSybase] Posted on 2004-12-17 10:42:14.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Licensing of a proxy database
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <03d5s0hs6f585uccc4q6vpl7bgf41fh3ee@4ax.com>
References: <41b83e69@forums-1-dub> <41b8599c$1@forums-2-dub> <41b87edd@forums-2-dub> <41bdb1e6$1@forums-1-dub> <41c16a00$1@forums-1-dub> <gos2s0lepebhbd2vjfh584gm9o1jppornc@4ax.com> <41c1957a$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ip67-93-228-42.z228-93-67.customer.algx.net
X-Original-NNTP-Posting-Host: ip67-93-228-42.z228-93-67.customer.algx.net
Date: 17 Dec 2004 02:42:14 -0800
X-Trace: forums-1-dub 1103280134 67.93.228.42 (17 Dec 2004 02:42:14 -0800)
X-Original-Trace: 17 Dec 2004 02:42:14 -0800, ip67-93-228-42.z228-93-67.customer.algx.net
Lines: 243
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3991
Article PK: 7883

Connection management with remote databases is a dark art to me, so
maybe you should start a new thread to get someone who *knows* to
answer.

I am fairly positive it does *not* open and close a connection with
each operation, at least for real databases like Oracle. I think it
opens one remote connection for each remote server definition that is
referenced by a main connection (the connection to ASA). By
"reference" I mean things like SELECT, CREATE EXISTING TABLE, etc. I
do *not* think that CREATE SERVER opens a connection; that means you
don't really know if you got it right until you make a reference. I
believe the connection is held open as long as the main connection is
held open. I am not sure that DROP SERVER severs the connection; it
should, IMO, and it did not in the past, but that may have changed...
I don't know, all my old code is written to work on previous versions,
and all my new code runs as web services in which ASA connections are
opened and closed at frenetic rate so remote connections are as well.

Anyway, there's no connection cache.

Be careful if you are trying to do distributed transaction processing;
a recent thread here discussed this. I don't have much experience with
that, stick mostly to SELECT, and batch bulk transfers
(INSERT...SELECT and operations like that).

Do not expect very high performance data transfer. You *can* do things
with FORWARD TO; e.g., I use UNLOAD SELECT and FORWARD TO...BULK
INSERT when shipping masses of data from ASA to MSS; I dunno if Oracle
has a fast load SQL statement. Anyway, it's reached 8000 rows (800K)
per second by that route.

Breck

On 16 Dec 2004 06:02:34 -0800, "Chris Werner"

<cw[please_no_spam]@f-s.de> wrote:

>Hi Breck,
>
>thank you very much for your detailed explanation and
>right, nobody should want to use Oracles (+) operator
>but sometimes - declared - it is comfortable short. (Don't
>want to argue here.)
>
>At the time being I have no question of the form "How
>do I do ..." but I wonder how ASA maintains the
>connections to Oracle? Is there something like a connection
>cache or will ASA reconnect for every single statement?
>That would'nt violate transaction processing and slow
>down processing.
>
>Regards
>
> Chris Werner
>
>
>"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> schrieb im
>Newsbeitrag news:gos2s0lepebhbd2vjfh584gm9o1jppornc@4ax.com...
>> Proxy tables are *SQL Anywhere* tables, not Oracle tables, as far as
>> the syntax of SQL statements issued to the SQL Anywhere database is
>> concerned. For example, you will not be able to use the Oracle "(+)"
>> outer join operator in a WHERE clause (not that you would want to, but
>> that's not my point here :)
>>
>> You can do *lots* of stuff with Oracle via proxy tables, and there are
>> workarounds for some of the issues; one popular trick is to create a
>> view on the Oracle side, since a proxy table can map to a view as well
>> as a table. The FORWARD TO statement is powerful as well, although I
>> haven't been able to get it to return a result set in any environment
>> except ISQL (gosh, that would be nice!)
>>
>> For example, I use SQL Anywhere stored procedures to display the
>> Oracle catalog tables in HTML, whenever I visit a client using Oracle
>> (see http://www.risingroad.com/toolbox.html )... proxy tables are used
>> to suck the Oracle catalog into an environment where the SQL syntax
>> truly rocks! (with apologies to Oracle fans, it ranks well ahead of
>> DB2 in my opinion, but nowhere *near* SQL Anywhere in terms of
>> language features :)
>>
>> Post new messages asking "How do I do <this thing> with Oracle proxy
>> tables?" and we'll try to answer.
>>
>> Breck
>>
>> On 16 Dec 2004 02:57:04 -0800, "Chris Werner"
>> <cw[please_no_spam]@f-s.de> wrote:
>>
>> >Thanks for your answer. One question comes
>> >into my mind. The SQL dialect differs between
>> >ASA and ORA (operators, functions, outer joins).
>> >Can I use full ORA functionality with this
>> >architecture? What dialect I have to use?
>> >
>> >TIA
>> >
>> > Chris Werner
>> >
>> >
>> >
>> >
>> >"Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im Newsbeitrag
>> >news:41bdb1e6$1@forums-1-dub...
>> >> Yes your proposed architecture is physically possible, although it does
>> >> depend on the stability of your connection. In a controlled environment
>> >> using a wireless LAN connection, the connection is quite probably
>> >reliable.
>> >>
>> >> --
>> >> -----------------------------------------------
>> >> Robert Waywell
>> >> Sybase Adaptive Server Anywhere Developer - Version 8
>> >> Sybase Certified Professional
>> >>
>> >> Sybase's iAnywhere Solutions
>> >>
>> >> Please respond ONLY to newsgroup
>> >>
>> >> EBF's and Patches: http://downloads.sybase.com
>> >> choose SQL Anywhere Studio >> change 'time frame' to all
>> >>
>> >> To Submit Bug Reports:
>> >>
>>
>>http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=
>B
>> >ug
>> >>
>> >> SQL Anywhere Studio Supported Platforms and Support Status
>> >> http://my.sybase.com/detail?id=1002288
>> >>
>> >> Whitepapers, TechDocs, and bug fixes are all available through the
>> >iAnywhere
>> >> Developer Community at www.ianywhere.com/developer
>> >>
>> >> "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
>> >> news:41b87edd@forums-2-dub...
>> >> > Thank you very much for your help.
>> >> >
>> >> > I don't want synchronize using mobilink but
>> >> > use an online connection to the enterprise
>> >> > database which is oracle. So my pocketbuilder
>> >> > application uses an ASA client to connect
>> >> > (via WAN) to the ASA server database which
>> >> > contains proxy tables to get access to the oracle
>> >> > tables. This should be possible if I understand
>> >> > the concept of proxy tables right?
>> >> >
>> >> > Thanks again
>> >> >
>> >> > Chris Werner
>> >> >
>> >> >
>> >> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> schrieb im
>Newsbeitrag
>> >> > news:41b8599c$1@forums-2-dub...
>> >> > > Physically, with a proxy table connection from an ASA database to
>an
>> >> > Oracle
>> >> > > database, the ASA database is just a client application. The
>licensing
>> >> for
>> >> > > that client connection will depend on Oracle's requirements in this
>> >> case,
>> >> > so
>> >> > > you would need to check with them.
>> >> > >
>> >> > > Having said that, is there a particular reason why you would want
>to
>> >> > > implement a middle tier ASA consolidated database as opposed to
>having
>> >> the
>> >> > > handhelds synchronize directly against Oracle using MobiLink?
>> >> > >
>> >> > > --
>> >> > > -----------------------------------------------
>> >> > > Robert Waywell
>> >> > > Sybase Adaptive Server Anywhere Developer - Version 8
>> >> > > Sybase Certified Professional
>> >> > >
>> >> > > Sybase's iAnywhere Solutions
>> >> > >
>> >> > > Please respond ONLY to newsgroup
>> >> > >
>> >> > > EBF's and Patches: http://downloads.sybase.com
>> >> > > choose SQL Anywhere Studio >> change 'time frame' to all
>> >> > >
>> >> > > To Submit Bug Reports:
>> >> > >
>> >> >
>> >>
>>
>>http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=
>B
>> >> > ug
>> >> > >
>> >> > > SQL Anywhere Studio Supported Platforms and Support Status
>> >> > > http://my.sybase.com/detail?id=1002288
>> >> > >
>> >> > > Whitepapers, TechDocs, and bug fixes are all available through the
>> >> > iAnywhere
>> >> > > Developer Community at www.ianywhere.com/developer
>> >> > >
>> >> > > "Chris Werner" <cw[please_no_spam]@f-s.de> wrote in message
>> >> > > news:41b83e69@forums-1-dub...
>> >> > > > Hi all,
>> >> > > >
>> >> > > > I discuss with a customer solutions to make
>> >> > > > an oracle database accessible on mobile
>> >> > > > devices using pocketbuilder and ASA as
>> >> > > > local database and server database containing
>> >> > > > proxy tables which points to tables in the oracle
>> >> > > > database. The customer claims that he would
>> >> > > > need 2 licenses for every mobile device, one
>> >> > > > local license for the device and one connection
>> >> > > > license for the proxy database. Is that right?
>> >> > > >
>> >> > > > TIA
>> >> > > >
>> >> > > > Chris Werner
>> >> > > >
>> >> > > >
>> >> > >
>> >> > >
>> >> >
>> >> >
>> >>
>> >>
>> >
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> Buy the book:
>http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>> bcarter@risingroad.com
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com