SQL Anywhere Mobile - external file

Author

external file

Eric Verhorstert

2005-07-15, 3:25 am

ASA 9

Is it possible to synchronise allways an external file (about 100 bytes)
with mobilink?

Thanks
Eric

Reg Domaratzki \(iAnywhere Solutions\)

2005-07-15, 7:24 am

Can you define what you mean by "synchronize an external file" ?
Also, what consolidated database are you using, and can you confirm that you
are using ASA remotes?

--
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 "Platform Preview" and "Time Frame" to ALL

"Eric Verhorstert" <ontsnapt@hotmail.com> wrote in message
news:42d77779@forums
-2-dub...
> ASA 9
>
> Is it possible to synchronise allways an external file (about 100 bytes)
> with mobilink?
>
> Thanks
> Eric

Eric Verhorstert

2005-07-18, 3:23 am

Both the consolidated and remote database are ASA 9.

External file is for example c:\autoexec.bat. In our case it would be a
license file of our program. Synchonize might not be the correct word
because what I want to do is to send it to the remote before or after
the mobilink synchonization.

Thanks,
Eric

Reg Domaratzki (iAnywhere Solutions) wrote:
> Can you define what you mean by "synchronize an external file" ?
> Also, what consolidated database are you using, and can you confirm that you
> are using ASA remotes?
>

Breck Carter [TeamSybase]

2005-07-18, 3:23 am

You can create your own table with a LONG BINARY or LONG VARCHAR
column for the file contents, use INSERT SELECT xp_read_file() or an
application to insert values on the consolidated database, MobiLink to
download the rows, and SELECT xp_read_file() or an application on the
remote database side. Consider using a hook procedure like
sp_hook_dbmlsync_sch
ema_upgrade on the remote side; "schema upgrades"
aren't the only kind of upgrades that you can do there, "file
deployment" is also possible... even setup.exe's :)

Breck

On 17 Jul 2005 22:48:27 -0700, Eric Verhorstert <ontsnapt@hotmail.com>
wrote:
[color=darkred]
>Both the consolidated and remote database are ASA 9.
>
>External file is for example c:\autoexec.bat. In our case it would be a
>license file of our program. Synchonize might not be the correct word
>because what I want to do is to send it to the remote before or after
>the mobilink synchonization.
>
>Thanks,
>Eric
>
>
>
>Reg Domaratzki (iAnywhere Solutions) wrote:

--
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