I have found many posts regarding this issue, but still unable to solve the problem. Maybe you'll have ideas or queues of where to look at to try to solve it.
One of our customer is using our .NET application, in a Citrix environment, and reported a persistent error when trying to generate Crystal Reports. Our application allows to generate Crystal Reports using the ADO.NET(XML) data connector, and the specific version of Crystal used by our customer is the Crystal Reports XI Runtime.
When trying to generate a Crystal Reports, the XML temporary file is generated successfully, but when the Crystal runtime comes to feed the temporary RPT file with the XML file he keeps getting the "Unable to connect" error.
I believe the most frequent causes of this issue are either a security issue or a mismatch of the database schema/data. I have investigated both. The generated XML data file is correct and database schema is coherent, and also it all works fine in the Crystal Reports Designer tool. As for the security I confirm that the user has writing rights to the folder where the temporary XML file is and all required access levels.
Any idea regarding that issue will be greatly appreciated.
Thank you