SQL Anywhere Mobile - How would you tackle this ?

Author

How would you tackle this ?

Scott Baker

2005-03-31, 8:04 pm

Hi,
Can mobilink / ultralite be used to synchronize with a host
application that does not have a database? For instance
let's say the host side of an application is simply a telnet
session to another computer. Is it possible to tell the
Mobilink server to run a script that goes out and connects
to the telnet session and issues a command that retrieves
data and spits it back out to the client?

Would this be possible by calling a stored procedure in a
temporary database (one that just houses some stored procs
to access the telnet session) or using Java in a temporary
database? We really don't have a consolodated database,
just a telnet interface that we need to talk through to get
our data.

I guess I've found it so easy to use Mobilink, I am looking
for a way to make it work in this situation. The main
thing I am trying to do is synchronize to a telnet session
and not a database.

Thanks,

David Fishburn

2005-03-31, 8:04 pm

Scott Baker wrote in news:424c58f3.6ff9.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

SB> Can mobilink / ultralite be used to synchronize with a host
SB> application that does not have a database? For instance
SB> let's say the host side of an application is simply a telnet
SB> session to another computer. Is it possible to tell the
SB> Mobilink server to run a script that goes out and connects
SB> to the telnet session and issues a command that retrieves
SB> data and spits it back out to the client?
SB>
SB> Would this be possible by calling a stored procedure in a
SB> temporary database (one that just houses some stored procs
SB> to access the telnet session) or using Java in a temporary
SB> database? We really don't have a consolodated database,
SB> just a telnet interface that we need to talk through to get
SB> our data.
SB>
SB> I guess I've found it so easy to use Mobilink, I am looking
SB> for a way to make it work in this situation. The main
SB> thing I am trying to do is synchronize to a telnet session
SB> and not a database.

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

Two items:

1. You can use Java or .Net scripts to do whatever you want. If you
have use either of those languages to talk to telnet, all the power
to you. You still must return the data to UL via rows in a table.
So you must use telnet to get the data, then stuff it in a table in
an ASA consolidated (staging database?) and send it down via the
download_cursor. (See #2)

2. For our Jasper release, we have opened up our API. You have access
to objects that contain both the upload and download. So you could
simply add data to the download, without having to run any SQL
against a database. This should address any "but I really need to
do this ...".

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

Sponsored Links