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,hostna me.

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\RD P-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]

Re: sp_who and Citrix

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