Search found 1168 matches

by Tom
Tue Nov 28, 2023 7:35 am
Forum: eXpress++ Support
Topic: rm chart
Replies: 4
Views: 1324

Re: rm chart

We just register the component (manifest-driven), no problems at any client sites. All kinds of OSes in use.

But we remove all rmcharts step by step and replace them with cool JavaScript charts embedded in HTML-documents, shown using the XbpHtmlViewer2.
by Tom
Sun Nov 19, 2023 4:30 am
Forum: phpBB Board Support
Topic: Recovering from surgery
Replies: 6
Views: 2761

Re: Recovering from surgery

Get well soon, Roger!
Hopefully, I will be able to smell and taste food again.
I hope the same for you too.
by Tom
Thu Nov 16, 2023 7:02 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

Re: ADS: sp_mgGetUserTables() with same user name

SQL_STATEMENT_LIMIT means the maximum number of statements for one connection at a time . It's really hard to reach this limit as long as all statements are properly finished and closed. See correction of my message. Another alternative is to set a Registry Value: SQL_STATEMENT_LIMIT (DWORD) in \HKE...
by Tom
Thu Nov 16, 2023 2:56 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

Re: ADS: sp_mgGetUserTables() with same user name

The username is W2016SVR on each connection This is the name of the computer connecting to the ADS , which only is an user name in terms of the ADS. The OS User Login Name is the real username. Anyhow, you get all this information (including the TSAddress) with "sp_mgGetTableUsers()", so it's easy ...
by Tom
Tue Nov 14, 2023 6:08 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

Re: ADS: sp_mgGetUserTables() with same user name

Addition: Using those stored procedures again and again may lead to ADS Error 7216, which means the number of SQL-statements for that connection is exceeded. sp_SetStatementLimit(0) solves that problem. Edit: Correcting a misbehaviour solves the problem aswell. I took the functions from ADSMGT.PRG, ...
by Tom
Tue Nov 14, 2023 5:58 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

Re: ADS: sp_mgGetUserTables() with same user name

To mention Marcus again:

He pointed out to me that the "Connection number" only worked in the context of NetWare and has been de-supported for quite a while. ;)
by Tom
Tue Nov 14, 2023 1:53 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

Re: ADS: sp_mgGetUserTables() with same user name

Found a way, Marcus Herz from the german forum helped me. If I retrieve all user tables open for a user name (which is the computer name), I can walk through the result list and find out using "sp_mgGetTableUsers(<cTable>)", which TSAddress or OSLoginUserName is attached to every open table. This gi...
by Tom
Tue Nov 14, 2023 1:17 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

Re: ADS: sp_mgGetUserTables() with same user name

What I need is a way to find the tables used by an ADS user with a special "TSAddress". This information is unique even on a Terminal Server.
by Tom
Tue Nov 14, 2023 12:17 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

Re: ADS: sp_mgGetUserTables() with same user name

To track users who have open files eg. program running so you can kick it out of exe for maintenance? To track users who have special files open. I'm talking about a situation with 200+ users in a mixed environment, about half of them using a TS with the same user name on that TS (which is standard...
by Tom
Mon Nov 13, 2023 8:49 am
Forum: eXpress++ Support
Topic: ADS: sp_mgGetUserTables() with same user name
Replies: 19
Views: 3668

ADS: sp_mgGetUserTables() with same user name

Hi, there. In a topology that runs on (among other things) a terminal server, all users who connect to the ADS have the same username under most installation circumstances. If you retrieve further information about this with sp_mgGetConnectedUsers(), you will get, for example, the actual user name w...