CR XI server install sp2 breaks report redirection in code

[Former Member]

<p>I&#39;m having problems redirecting reports opened in an app written with Visual Studio 2003 using Crystal Reports XI. </p><p>Until recently the application was able to redirect reports to whatever database our application was pointed to. In the code I change the connection info for each of the tables and then apply the changes before opening the report. It&#39;s the same code that appears in a number of places on the web.</p><p>However, once we update any of our clients to the most recent version of the server install that functionality stops working. We&#39;re not installing release 2, it&#39;s just the most recent version of the server install. I think it corresponds to CR sp2, but it&#39;s not really labeled properly so it&#39;s hard to tell.</p><p>When I try to open the report from within our app using sp2, it pops up with an error message saying:</p><p>Failed to open the connection<br />Details: [Database Venfore Code: 17]<br />Failed to open the connection<br />C:\DOCUME......(path to report)<br />Details: [Database Vendor Code: 17]</p><p>When designing the report we&#39;re using CR XI sp1 with an OLEDB connection to a SQL server. In addition, if the database that the report was originally pointed to is available to the client, the report will point to that database and ignore the new connection settings without popping an error message. That made it difficult to detect in the first place.</p><p>Has anyone else run into similar issues? This is one of 3 Crystal Reports issues I&#39;m trying to troubleshoot right now. I&#39;m in the middle of a very long and very frustrating email correspondence with Business Objects&#39; email support, which I&#39;m starting to realize is completely useless.</p><p>Chris</p><p><img src="http://i87.photobucket.com/albums/k155/csrutledge/Error1.gif" alt="Crystal Reports connection error" width="536" height="159" /><br /></p>

[robert_horne · Accepted solution]

<p>Hi Chris</p><p>I haven&#39;t seen this before so I called people in support to take a look at this. They said that they haven&#39;t seen this before. If it was something that was affecting everyone there phones would be ringing off the hook. I talked to a resource there and they are reviewing your case to see how to get this fixed quickly. Sorry for the delay, they are working on it. </p><p>Rob Horne</p>

[Former Member]

Wow, these forums are just as informative as the Business Objects forums.