Home > Archive > SQL Anywhere Mobile > October 2005 > can remote (proxy) tables be published?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author can remote (proxy) tables be published?
Tom

2005-10-27, 5:29 pm

I have two ASA databases DB-A and DB-B. DB-A is mainly thought for use
with UltraLite databases (receives data from several PDAs). DB-B stores
in one table (DB-B_table-X) information that is being used in DB-A too
and parts of this table (some fields/columns) should be synchronized
with the ultralite database on the PDAs. Users on the PDA should be
possible to update this data.

I setup a remote server and made DB-B_table-X a proxy table in DB-A.
This works fine and I can access the data in stored procedures etc (only
need read only access). I tried to publish DB-B_table-X (the proxy
table) in DB-A but in Central it is not visible when I try to create a
new article under Publications .

Could somebody give me a hint, how to solve this problem?

Tom
Shuchit

2005-10-28, 3:24 am

Tom <tom@nospam.org> wrote in news:4360f39e$1@foru
ms-1-dub:

> I have two ASA databases DB-A and DB-B. DB-A is mainly thought for use
> with UltraLite databases (receives data from several PDAs). DB-B stores
> in one table (DB-B_table-X) information that is being used in DB-A too
> and parts of this table (some fields/columns) should be synchronized
> with the ultralite database on the PDAs. Users on the PDA should be
> possible to update this data.
>
> I setup a remote server and made DB-B_table-X a proxy table in DB-A.
> This works fine and I can access the data in stored procedures etc (only
> need read only access). I tried to publish DB-B_table-X (the proxy
> table) in DB-A but in Central it is not visible when I try to create a
> new article under Publications .
>


I do not think you can add proxy tables to a publications because the local
database does not track the transactions in the remote table in the local
transaction log.

Could you explain why you are trying to add a publication to DB-A ? Is it to
run ulinit or ulgen ?

Shuchit
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com