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.
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.
Hi All
Just wondering if anyone has experience with running SQL Server 7 with Citrix. We currently run Terminal Server for our business and now we are installing SQL Server 7 to run our main software package and we are being told that we should revert to a normal setup with workstations for each user rather than using our P75 terminals that we use with terminal server.
If all the procseeeing is being done by the server then surely we can just use the same low end boxes and just make sure that the server is crunching the data.
Thanks.....
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 RelatedHi,
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 ?
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?
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