qbjgqbjg
asked on
Crystal reports cannot connect on Citrix receiver
User has Crystal Reports that ran correctly a week ago, but now do not they get a message asking her to select an ODBC connection. The list does not have her connection in it. I have checked and the correct ODBC connection is on her machine. I will attach a copy of what she is seeing. This is happening for all her reports.
selectdsn.docx
selectdsn.docx
ASKER
It is Crystal XI. The other things I will have to check on.
ASKER
I had the user try the report from a different machine(also Citrix) that also has that ODBC connection loaded. She got the same error. They can run other crystal reports that access a different server using a different ODBC connection. On a regular machine, I can run the same reports sucessfully that fail on Citrix.
ASKER
Crystal is installed on the Citrix server and not on the localized images the users connect to.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If it is installed onthe server, will that override the ones installed on the user machines?
ASKER
No one could find anything that changed, but something must have.
I don't think the server ODBC will override a user ODBC unless you are running the application on the server.
mlmcc
mlmcc
ASKER
They are going to install it on the server. So tomorrow I will know if that works. I still think it is something else, since this was working a few weeks back and now it isn't.
ASKER
Are there security changes that could be made to a server that would cause an ODBC connection to no longer work for that server? And only not work from Citrix, but still work from a regular machine?
It is possible. I am not a system admin. It could be the ODBC connection is there but no one has permissions to it or it is a USER connection rather than a SYSTEM connection.
mlmcc
mlmcc
ASKER
I do not understand what you are saying. I am primarily a Crystal person. I know next to nothing about Citrix. The facts in this case are:
The ODBC connection to ServerA works for Regular machines.
The ODBC connection to ServerA worked for Citrix machines until a week ago, now it does not.
The ODBC connection to ServerA uses NT authentication.
ODBC connections for other servers still work from Citrix.
My conclusion is something changed for ServerA or something in Citrix relating to ServerA changed. So far everyone here says nothing changed.
The ODBC connection to ServerA works for Regular machines.
The ODBC connection to ServerA worked for Citrix machines until a week ago, now it does not.
The ODBC connection to ServerA uses NT authentication.
ODBC connections for other servers still work from Citrix.
My conclusion is something changed for ServerA or something in Citrix relating to ServerA changed. So far everyone here says nothing changed.
ASKER
I am still waiting for it to be installed on the Citrix server.
I think you are correct that something has changed. What changed is hard to say.
Hopefully installing the ODBC connection will solve the issue.
mlmcc
Hopefully installing the ODBC connection will solve the issue.
mlmcc
ASKER
This worked. Thanks for your help.
Has anything changed on the server or her machine?
What version of Crystal?
mlmcc