Page 2 of 2
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Thu Nov 16, 2023 2:56 am
by Tom
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 to find out who's really using a table.
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Thu Nov 16, 2023 4:32 am
by messaoudlazhar
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.
Alternative solution for error 7216: Adding SQL_STATEMENT_LIMIT=0
to the adslocal.cfg file
; Max Statement SQL Limit
; Default = 50
; This configuration parameter controls the maximum number of SQL statements that
; a single connection can keep open at one time. This option is ignored by
; setting this value to zero (0).
;
SQL_STATEMENT_LIMIT=0
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Thu Nov 16, 2023 7:02 am
by Tom
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 \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Thu Nov 16, 2023 11:25 am
by messaoudlazhar
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 \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Advantage\Configuration
this solution does not work. I tried it and it didn't change anything.
with SQL_STATEMENT_LIMIT=0 in the adslocal.cfg file, it works very well without limit.
Note: Put adslocal.cfg in the system32/sysWOW64 folder
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Thu Nov 16, 2023 1:07 pm
by bwolfsohn
I get an "attachment no longer exists" message when trying to view the .jpg
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Thu Nov 16, 2023 10:47 pm
by Wolfgang Ciriack
Hello Brian,
that is the message i always get with attachments from this forum.
Jimmi posted the solution:
Open the file in a new window.
The path is shown, f.e. ...bb.donnay-software.com/donnay/phpbb3/download/file.php?id=2241
Remove the "/phpbb3" from that path and the attachment is shown.
I hope, Roger will correct the path for attachments in that forum.
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Sat Nov 18, 2023 5:27 pm
by rdonnay
Open the file in a new window.
Open what file? how?
The path is shown, f.e. ...bb.donnay-software.com/donnay/phpbb3/download/file.php?id=2241
Remove the "/phpbb3" from that path and the attachment is shown.
I hope, Roger will correct the path for attachments in that forum.
I really don't know how to do this.
I have gone through the source code to figure out how PHP creates that path.
Also, I don't have any problem seeing the attachments in Edge browser.
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Mon Nov 20, 2023 3:29 am
by Wolfgang Ciriack
Hello Roger,
Open what file? how?
Right click on the name of the attachment and choosing "Open graphic in a new tab", then remove the phpbb3\ and it is shown.
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Tue Nov 21, 2023 8:13 am
by rdonnay
Right click on the name of the attachment and choosing "Open graphic in a new tab", then remove the phpbb3\ and it is shown.
I did as you suggested and the image shows just fine in a new tab with the below URL:
download/file.php?id=2255
Re: ADS: sp_mgGetUserTables() with same user name
Posted: Tue Nov 21, 2023 8:24 am
by bwolfsohn
Roger,
As an admin, you might have different rights and permissions. Can you access the board externally as a non-admin ?