|
Home > Archive > SQL Anywhere Mobile > August 2005 > Re: Is it possible to synchronize & insert,delete, update using the mobilink client's authentic
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 |
Re: Is it possible to synchronize & insert,delete, update using the mobilink client's authentic
|
|
|
| I found that, thanks anyway, however the purpose of setuser function is the
same in both databases.
But, I am wondering why dbmlserv is not designed to have user based DB
connection.
Even though web servers generally are made to run under ONE user's context
it is possible to run under individual users' context against a database.
Why dbmlsrv is designed to work only against one common user?
When I can open multiple threads for synchronization why not multiple db
connection?
I am trying to make parallel between pda->exchange server sync versus
mobilink.
Both does similar function (exchange of data) however their behaviour is
different.
Why?
thanks
vsv
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:4315f367@forums
-1-dub...
> Double Argh. The SETUSER command does not affect the return value of
> suser_name() in ASE. I was assuming that suser_name() in ASE was the
> equivalent of the CURRENT USER constant in ASA, which it is not.
>
> 1> select suser_name()
> 2> go
>
> ------------------------------
> sa
>
> (1 row affected)
> 1> setuser 'cons'
> 2> go
> 1> select suser_name()
> 2> go
>
> ------------------------------
> sa
>
> (1 row affected)
>
> The MobiLink Java API ( or the .NET API ) won't help either, because data
> values for upload are not passed into the upload_* JAVA or .NET scripts.
> The Java or .NET scripts only return a SQL statement which is then
executed
> through the ODBC connection.
>
> The only choice left if to handle every row as a conflict, and store the
> rows in temporary tables using the upload_old_row_inser
t and
> upload_new_row_inser
t events. You will then have an end_upload event for
> each table that calls a .NET or Java class. This Java class can make a
> connection to the ASE server (using whatever uid/pwd you choose) and
process
> the data. I'll post a quick sample on the other thread you opened.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "vsv" <nospam@nospam.com> wrote in message news:4315d8d6$1@foru
ms-2-dub...
Table[color=darkred]
> suser_name()
> completion
<FirstName.LastName@ianywhere.com>[color=darkred]
modifying[color=dark
red]
> able
> news:4315c489$1@foru
ms-1-dub...
&[color=darkred]
by[color=darkred]
a[color=darkred]
method[color=darkred
]
> this
> First,
'set[color=darkred]
> unless
> USER
> the
> our
>
>
|
|
|
|
|