The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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.

asked 30 Jul '14, 04:35

hakwoo's gravatar image

hakwoo
81448
accept rate: 0%


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

permanent link

answered 30 Jul '14, 05:35

Tom%20Slee's gravatar image

Tom Slee
1.2k21429
accept rate: 29%

1

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?

(30 Jul '14, 05:50) Volker Barth

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.

permanent link

answered 31 Jul '14, 11:03

PhilippeBertrand%20_SAP_'s gravatar image

PhilippeBert...
1.5k41735
accept rate: 22%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×295
×145
×32

question asked: 30 Jul '14, 04:35

question was seen: 932 times

last updated: 31 Jul '14, 11:03