SQL Anywhere Mobile - Re: Publications in Oracle or ASA???

Author

Re: Publications in Oracle or ASA???

Paul Carbajal

2005-03-30, 9:43 am

Well, i created mi scripts in Oracle but when i start the
sync i get an error msg "E. No synchronization subscription
found in the database". So i don=b4t know if i have to
create those pubs in oracle(i don=b4t know how either) or if
i have to create them in ASA.

Thanks again.

David Fishburn

2005-03-30, 9:43 am

Paul Carbajal wrote in news:4241f718.3a3c.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

PC> Well, i created mi scripts in Oracle but when i start the
PC> sync i get an error msg "E. No synchronization subscription
PC> found in the database". So i don´t know if i have to
PC> create those pubs in oracle(i don´t know how either) or if
PC> i have to create them in ASA.

A publication is an ASA thing, Oracle does not know what a "publication"
is.

What reported the error?
The error would have been reported by dbmlsync.exe. That is connecting
to the ASA database, so you know it is related to the remote database,
not the Oracle server.

If you followed the tutorial you would have created the following in the
REMOTE ASA database:
1. CREATE PUBLICATION pub_name ...
2. CREATE SYNCHRONIZATION USER user_name ...
3. CREATE SYNCHRONIZATION SUBSCRIPTION TO pub_name FOR user_name ...

If you had done those steps, then you would not have received the error
above.

Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Paul Carbajal

2005-03-30, 9:43 am

When i create a publication in ASA, mobilink syncs the whole
table, as i wrote before i only want to sync the result of a
query that is defined in my scripts in Oracle.
So i guess that the publication needs to be adressed to my
script, is that correct?? how do i do that??

Thanks,

Breck Carter [TeamSybase]

2005-03-30, 9:43 am

The publication on the ASA database control which tables and rows are
*uploaded*. By default, all rows in the named tables that have changed
since the last synchronization are uploaded, but you can add a WHERE
clause to the article in the publication to control that.

The *download* is controlled by download_cursor scripts on Oracle,
which you code as SELECT statements; use WHERE clauses to control
which rows are downloaded. This is discussed in the Help

MobiLink Administration Guide
Synchronization Techniques

Breck

On 28 Mar 2005 06:38:17 -0800, Paul Carbajal wrote:

>When i create a publication in ASA, mobilink syncs the whole
>table, as i wrote before i only want to sync the result of a
>query that is defined in my scripts in Oracle.
>So i guess that the publication needs to be adressed to my
>script, is that correct?? how do i do that??
>
>Thanks,

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

Sponsored Links