I can see who is mobilink user when we use SQL Anywhere for remote database. because I can connect to remote database using Sybase central and then there is mobilink user menu. But I am not sure how to check it on ultralite.. is it same as SQL Anywhere? is there any system data which can let us know who is mobilink user?
I use SA12.
Thanks in advance.
asked 30 Jul '14, 04:35
I don't think there is a way, because there need not be a one-to-one correspondence between ml_user and database, so the MobiLink user is specified in the SyncParms. The ml_remote_id property is a similar idea to the ml_user and it does identify the database to MobiLink and is a database property (see the documentationlink text). You can find the value by running
answered 30 Jul '14, 05:35
One slim chance is if you use sync profiles in your application and the application stored the ml_user in the profile. In this case you can use the function SYNC PROFILE OPTION VALUE (add underscores in the name - forum messes them up).
See CREATE SYNCHRONIZATION PROFILE statement for more information.
Tom's answer is the most general answer. The ml_remote_id is a better thing to look at to identify clients.
answered 31 Jul '14, 11:03