ADS: sp_mgGetUserTables() with same user name

This forum is for eXpress++ general support.
Message
Author
User avatar
Tom
Posts: 1155
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: ADS: sp_mgGetUserTables() with same user name

#11 Post 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.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

messaoudlazhar
Posts: 42
Joined: Mon Dec 23, 2013 2:10 pm
Contact:

Re: ADS: sp_mgGetUserTables() with same user name

#12 Post 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

User avatar
Tom
Posts: 1155
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: ADS: sp_mgGetUserTables() with same user name

#13 Post 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
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

messaoudlazhar
Posts: 42
Joined: Mon Dec 23, 2013 2:10 pm
Contact:

Re: ADS: sp_mgGetUserTables() with same user name

#14 Post 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

bwolfsohn
Posts: 648
Joined: Thu Jan 28, 2010 7:07 am
Location: Alachua, Florida USA
Contact:

Re: ADS: sp_mgGetUserTables() with same user name

#15 Post by bwolfsohn »

I get an "attachment no longer exists" message when trying to view the .jpg
Brian Wolfsohn
Retired and traveling around the country to music festivals in my RV.
OOPS.. Corona Virus, so NOT traveling right now...
http://www.breadmanrises.com
FB travel group: The Breadman Rises

Wolfgang Ciriack
Posts: 475
Joined: Wed Jan 27, 2010 10:25 pm
Location: Berlin Germany

Re: ADS: sp_mgGetUserTables() with same user name

#16 Post 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.
_______________________
Best Regards
Wolfgang

User avatar
rdonnay
Site Admin
Posts: 4712
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: ADS: sp_mgGetUserTables() with same user name

#17 Post 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.
The eXpress train is coming - and it has more cars.

Wolfgang Ciriack
Posts: 475
Joined: Wed Jan 27, 2010 10:25 pm
Location: Berlin Germany

Re: ADS: sp_mgGetUserTables() with same user name

#18 Post 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.
_______________________
Best Regards
Wolfgang

User avatar
rdonnay
Site Admin
Posts: 4712
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: ADS: sp_mgGetUserTables() with same user name

#19 Post 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
The eXpress train is coming - and it has more cars.

bwolfsohn
Posts: 648
Joined: Thu Jan 28, 2010 7:07 am
Location: Alachua, Florida USA
Contact:

Re: ADS: sp_mgGetUserTables() with same user name

#20 Post by bwolfsohn »

Roger,

As an admin, you might have different rights and permissions. Can you access the board externally as a non-admin ?
Brian Wolfsohn
Retired and traveling around the country to music festivals in my RV.
OOPS.. Corona Virus, so NOT traveling right now...
http://www.breadmanrises.com
FB travel group: The Breadman Rises

Post Reply