Host_id() And Citrix
Nov 3, 2006
Hi,
I'm wondering about the behaviour of the HOST_ID() function with clients running on a Citrix server.
As I said in my post about "dynamical views", I'd like to use the host_id as a terminal ID, assuming this number will be unique.
In my current configuration, each user has a client on his workstation which connects to SQL Server, an it works fine. But what happens if i migrate my clients on a Citrix server. Will I always have the same host_id or not ?
View 3 Replies
Aug 29, 2007
I'm trying to make an DTS which concet to oracle driver.
When I make an DTS in client SQL Sever installed locally (PC) it does conect. But when I use the client from Citrix MetaFrame it does NOT conect.
Any suggestion?... Thanks in advance.
In quiet oceans, all ships have a good captain.
View 5 Replies
View Related
Jul 31, 2006
I have some users on Citrix, running an Access front end with ODBCattached tables.In sp_who. on a normal workstation they'd usually show once or maybemore but all with the same hostname so counting actual number of usersis easy, group on loginame,hostname.When someone connects from a Citrix server, I append the connectionnumber to the workstation name in the connect string so the hostnamelooks something like "CITRIXBOXICA-tcp#256" also for terminal servicesthe hostname will look like "GANDALFRDP-Tcp#8".The problem is that on Citrix the user appears twice with a differenttcp number, the hostname is made up of the name of the citrix/ts server+ the environment variable %SESSIONNAME%, which is surely static for asession?Has anyone seen this in Citrix? Does it ghost old connections? I loogedout and in again just now and saw the sessions look like:CITRIXBOXICA-tcp#199 & CITRIXBOXICA-tcp#254 for my user name thenafter re-logging on I got CITRIXBOXICA-tcp#199 & CITRIXBOXICA-tcp#256so that session 199 has stuck there but wasn't visible in sp_who whilenot logged into the Citrix box.
View 1 Replies
View Related
Jan 21, 2008
What do I have to do to set up replication over Citrix Metaframe? Right now, the best I can do is to export tables from one database, and then import them into the other database over the Citrix link.
Thanks in advance for any help.
View 3 Replies
View Related
Nov 15, 2007
I have an Access front-end with a SQL backend. The access front-end connects to a different database dependent on the user and function . The user is prompted to select a database and a new dsn is passed to reconnect the sql tables to the selected database. The program is run both locally and over Citrix. The program has run without error for 2+ years. Yesterday, I made a change to an ocx on 1 form and now I cannot connect via Citrix. The application runs without error locally. When I try to connect via Citrix, I get a SQL Login error SQL State 01S00 Error 4060. When I step through the code locally, the code runs as it should and does not error.
Any ideas?
View 1 Replies
View Related
Oct 2, 2006
Hi,
I'm at a loss as to why i am getting the following error:
Retrieving the COM class factory for component CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E}failed due to the following error: 80040154
I am calling the package from a C# application which i have installed within a citrix environment. The application works without any trouble on my development machine but as soon as i run the code that executes the SSIS pacakge i get the error. Can anyone enlighten me as to what is causing this?
Many thanks in advance,
Grant
View 4 Replies
View Related
