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.

define more syncrn. Versions for Mobilink Server!

6 posts in General Discussion Last posting was on 2003-07-18 05:14:47.0Z
Matani Posted on 2003-07-16 12:20:57.0Z
Reply-To: "Matani" <S.Matani@ads-tec.de>
From: "Matani" <saleh@matani.net>
Subject: define more syncrn. Versions for Mobilink Server!
Date: Wed, 16 Jul 2003 14:20:57 +0200
Lines: 17
Organization: sudent
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <OyGpSX5SDHA.298@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gabriel.le1.ads-tec.de 62.153.239.43
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1351
Article PK: 3586

i have defined 3 Versions of Mobilnk Server and want to run defferant
Clients to user >Deferrent Server Scripts
for Client1
dbmlsync -c "dsn=MLClient" -ot dbmlsync.log -v -e "sv=Version1"
for Client 2
dbmlsync -c "dsn=MLClient" -ot dbmlsync.log -v -e "sv=Version2"

is this ok ?
because wenn i am running the client i do not getting any Error but it also
dose not syncr. the database!

Matani


Greg Fenton Posted on 2003-07-16 13:58:18.0Z
Date: Wed, 16 Jul 2003 09:58:18 -0400
From: Greg Fenton <greg.fenton_NOSPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: define more syncrn. Versions for Mobilink Server!
References: <OyGpSX5SDHA.298@forums-2-dub>
In-Reply-To: <OyGpSX5SDHA.298@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <OKF29N6SDHA.349@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gfenton-xp.sybase.com 172.31.140.253
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1354
Article PK: 3589


Matani wrote:
> for Client1
> dbmlsync -c "dsn=MLClient" -ot dbmlsync.log -v -e "sv=Version1"
> for Client 2
> dbmlsync -c "dsn=MLClient" -ot dbmlsync.log -v -e "sv=Version2"
>
> is this ok ?

Please, ALWAYS post the version and build number of ASA that you are
using (e.g. 8.0.2.4272, which you can get with the command "dbeng8 -v")

The above is completely valid, assuming that Client 1 and Client 2 are
separate databases. (It is also valid if they are the *same* database,
but doing this would likely lead to all sorts of data problems).

What do you mean when you say that "no sync occurs". Is ML getting the
synchronization request? Is it successfully completing the request?

If you haven't already done so, start the ML server with verbose flags
and log its output to a file:

dbmlsrv8 -c "dsn=..." -v+ -o ml.out

Then look at the output in ml.out to see what happened during both the
Client 1 and Client 2 synch's. With "-v+", even the row data that is
uploaded and downloaded is logged so you can tell exactly what was sent.

If you see any errors or are confused by the information therein, post a
new thread with specific questions.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Matani Posted on 2003-07-16 15:13:11.0Z
Reply-To: "Matani" <S.Matani@ads-tec.de>
From: "Matani" <saleh@matani.net>
References: <OyGpSX5SDHA.298@forums-2-dub> <OKF29N6SDHA.349@forums-2-dub>
Subject: Re: define more syncrn. Versions for Mobilink Server!
Date: Wed, 16 Jul 2003 17:13:11 +0200
Lines: 62
Organization: sudent
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <uvZtq66SDHA.346@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gabriel.le1.ads-tec.de 62.153.239.43
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1357
Article PK: 3591

i am using version 7.0.0.0000 and can not upgrade!

what i need is exactly filtering the syncrn. table rows
cust_id cust_name
-------- ----------
100001 aaaaa
100002 bbbb
200001 ccccc
200002 ddddd
300001 eeeee

table cust ,the cust_id is the PK and i want that the Mobilink Client Upload
all rows witch has 1% an download all rows from Server witch not 1%

how can i do this?
thank you for supporting
Matani

"Greg Fenton" <greg.fenton_NOSPAM@ianywhere.com> wrote in message
news:OKF29N6SDHA.349@forums-2-dub...
> Matani wrote:
> > for Client1
> > dbmlsync -c "dsn=MLClient" -ot dbmlsync.log -v -e "sv=Version1"
> > for Client 2
> > dbmlsync -c "dsn=MLClient" -ot dbmlsync.log -v -e "sv=Version2"
> >
> > is this ok ?
>
> Please, ALWAYS post the version and build number of ASA that you are
> using (e.g. 8.0.2.4272, which you can get with the command "dbeng8 -v")
>
> The above is completely valid, assuming that Client 1 and Client 2 are
> separate databases. (It is also valid if they are the *same* database,
> but doing this would likely lead to all sorts of data problems).
>
> What do you mean when you say that "no sync occurs". Is ML getting the
> synchronization request? Is it successfully completing the request?
>
> If you haven't already done so, start the ML server with verbose flags
> and log its output to a file:
>
> dbmlsrv8 -c "dsn=..." -v+ -o ml.out
>
> Then look at the output in ml.out to see what happened during both the
> Client 1 and Client 2 synch's. With "-v+", even the row data that is
> uploaded and downloaded is logged so you can tell exactly what was sent.
>
> If you see any errors or are confused by the information therein, post a
> new thread with specific questions.
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
>


Greg Fenton Posted on 2003-07-16 16:20:52.0Z
Date: Wed, 16 Jul 2003 12:20:52 -0400
From: Greg Fenton <greg.fenton_NOSPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: define more syncrn. Versions for Mobilink Server!
References: <OyGpSX5SDHA.298@forums-2-dub> <OKF29N6SDHA.349@forums-2-dub> <uvZtq66SDHA.346@forums-2-dub>
In-Reply-To: <uvZtq66SDHA.346@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <uI29od7SDHA.145@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gfenton-xp.sybase.com 172.31.140.253
Lines: 40
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1360
Article PK: 3595


Matani wrote:

> i am using version 7.0.0.0000 and can not upgrade!

The build number cannot be 0000. To find out the build number, use the
command "dbeng7 -v" or look at the first few lines of the database
console when the engine first starts up.

Also, are all of your databases (consolidated, remotes) running the
exact same version?

>
> table cust ,the cust_id is the PK and i want that the Mobilink Client Upload
> all rows witch has 1% an download all rows from Server witch not 1%
>
> how can i do this?

ML clients (or "remotes databases") only ever upload information that
has been inserted, deleted or updated in the tables of their
publication(s) since the publication was created. If you create a
publication on a table that already has data, that existing data will
not automatically be uploaded. Though there are techniques to get this
data uploaded (for example, unload the table and reload that data after
the publication has been created).

For the download, data is selected from the consolidated database by
MobiLink by the code in your download_cursor script.

Can you post the code for the upload_cursor and download_cursor for your
cust table? These scripts are stored in the ML tables on the
consolidated and can be accessed via the MobiLink plugin in Sybase Central.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Matani Posted on 2003-07-16 16:46:47.0Z
Reply-To: "Matani" <S.Matani@ads-tec.de>
From: "Matani" <saleh@matani.net>
References: <OyGpSX5SDHA.298@forums-2-dub> <OKF29N6SDHA.349@forums-2-dub> <uvZtq66SDHA.346@forums-2-dub> <uI29od7SDHA.145@forums-2-dub>
Subject: Re: define more syncrn. Versions for Mobilink Server!
Date: Wed, 16 Jul 2003 18:46:47 +0200
Lines: 81
Organization: sudent
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#dSY6r7SDHA.349@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gabriel.le1.ads-tec.de 62.153.239.43
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1362
Article PK: 3596

yes
this is the code that i wrote

upload script:
select cust_id,cust_name from cust where cust_id=?

download script:
select cust_id,cust_name from cust

i have 5 Databses and one Server
all of them have the same Tables
i need that the Client_1 upload the Rows witch hase been changed or inserted
on PC1 and download the rows from server witch has been uploaded from the
other 4 Clients.
every Database hase a deffirent PUBLIC.GLOBAL_DATABASE_ID witch make every
Database having a deffirent PK Value
for example:
cust_id cust_name
-------- ----------
100001 aaaaa - from Client_1
100002 bbbb
200001 ccccc -From Client_2
200002 ddddd
300001 eeeee - From Client_3

i need to crate scripts to be sure that wenn somebody change date for
Client1 from Client2 not to be syncr.

thank you for supporting and i am sorry writing the Q 2 times in differant
newsgroups!

"Greg Fenton" <greg.fenton_NOSPAM@ianywhere.com> wrote in message
news:uI29od7SDHA.145@forums-2-dub...
> Matani wrote:
>
> > i am using version 7.0.0.0000 and can not upgrade!
>
> The build number cannot be 0000. To find out the build number, use the
> command "dbeng7 -v" or look at the first few lines of the database
> console when the engine first starts up.
>
> Also, are all of your databases (consolidated, remotes) running the
> exact same version?
>
> >
> > table cust ,the cust_id is the PK and i want that the Mobilink Client
Upload
> > all rows witch has 1% an download all rows from Server witch not 1%
> >
> > how can i do this?
>
> ML clients (or "remotes databases") only ever upload information that
> has been inserted, deleted or updated in the tables of their
> publication(s) since the publication was created. If you create a
> publication on a table that already has data, that existing data will
> not automatically be uploaded. Though there are techniques to get this
> data uploaded (for example, unload the table and reload that data after
> the publication has been created).
>
> For the download, data is selected from the consolidated database by
> MobiLink by the code in your download_cursor script.
>
> Can you post the code for the upload_cursor and download_cursor for your
> cust table? These scripts are stored in the ML tables on the
> consolidated and can be accessed via the MobiLink plugin in Sybase
Central.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
>


Greg Fenton Posted on 2003-07-18 05:14:47.0Z
Date: Fri, 18 Jul 2003 01:14:47 -0400
From: Greg Fenton <greg.fenton_NOSPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: define more syncrn. Versions for Mobilink Server!
References: <OyGpSX5SDHA.298@forums-2-dub> <OKF29N6SDHA.349@forums-2-dub> <uvZtq66SDHA.346@forums-2-dub> <uI29od7SDHA.145@forums-2-dub> <#dSY6r7SDHA.349@forums-2-dub>
In-Reply-To: <#dSY6r7SDHA.349@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <#cP9yyOTDHA.298@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: vpn-concord-062.sybase.com 158.159.8.62
Lines: 22
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1391
Article PK: 3625


Matani wrote:
>
> i need to crate scripts to be sure that wenn somebody change date for
> Client1 from Client2 not to be syncr.
>

Well, one way is to design your application so that such updates cannot
occur. However, if this is something you need to enforce via
synchronization scripts and you are using ML 7.0.x, you will need to
look at using the "forced conflict" technique.

I can't seem to find the phrase "forced conflict" in the 7.0.x online
docs. But a quick search on Google for "mobilink forced conflict
upload_cursor" got a the 8.0.x docs as posted on sybase.com.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/