sp_who and Citrix

[Trevor Best]

I have some users on Citrix, running an Access front end with ODBC
attached tables.

In sp_who. on a normal workstation they'd usually show once or maybe
more but all with the same hostname so counting actual number of users
is easy, group on loginame,hostname.

When someone connects from a Citrix server, I append the connection
number to the workstation name in the connect string so the hostname
looks something like "CITRIXBOX\ICA-tcp#256" also for terminal services
the hostname will look like "GANDALF\RDP-Tcp#8".

The problem is that on Citrix the user appears twice with a different
tcp number, the hostname is made up of the name of the citrix/ts server
+ the environment variable %SESSIONNAME%, which is surely static for a
session?

Has anyone seen this in Citrix? Does it ghost old connections? I looged
out and in again just now and saw the sessions look like:

CITRIXBOX\ICA-tcp#199 & CITRIXBOX\ICA-tcp#254 for my user name then
after re-logging on I got CITRIXBOX\ICA-tcp#199 & CITRIXBOX\ICA-tcp#256
so that session 199 has stuck there but wasn't visible in sp_who while
not logged into the Citrix box.

[Trevor Best]

Trevor Best wrote:

Has anyone seen this in Citrix? Does it ghost old connections? I looged
out and in again just now and saw the sessions look like:

CITRIXBOX\ICA-tcp#199 & CITRIXBOX\ICA-tcp#254 for my user name then
after re-logging on I got CITRIXBOX\ICA-tcp#199 & CITRIXBOX\ICA-tcp#256
so that session 199 has stuck there but wasn't visible in sp_who while
not logged into the Citrix box.

I found the problem, for the benefit of future googlers the tabledefs in
Access were stamped with the first connection number
"WSID=CITRIXBOX\ICA-tcp#199" and in a subsequent session a new
connection was opened to the server with "WSID=CITRIXBOX\ICA-tcp#254" so
as a linked table was opened along with the connection it looks like 2
workstations (or specifically 2 citrix sessions) connecting.

Thanks to all who participated here, that'll be me then :-)