How can we check who is moblink user when we use ultralite?

[Former Member]

Dear all,

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.

[Former Member · Accepted solution]

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

select db_property('ml_remote_id')

[VolkerBarth · Accepted solution]

FWIW, here's a possibly related question (with a similar answer, not surprisingly):

How do I get the ML_REMOTE_ID of an UDB in an application?

[philippefbertrand]

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.