Recently I started migrating our reporting solution from Crystal Reports 10 to Crystal Reports XI Release 2. We had switched from .NET 1.1 to .NET 2.0, and had been running CR 10 fairly well. Unfortunately, one of our other vendors doesn’t support using anything except CR XI. To install CR XI with Visual Studio 2005, Crystal Reports recommends using Release 2. For the most part, converting from CR 10 to CR XI Release 2 has gone smoothly. Except for one small, insignificant little problem… when running on the production web server, I would get a Class Not Registered – DTSConnection error.
Here’s the setup. Windows 2003 Server, IIS 6.0, ASP.NET 2.0, Crystal 10 Server components install and Crystal XI R2 server install. I have the web applications setup under the main site. Some of the apps use the CR 10 components and the new apps use the CR XI R2 components.
Fortunately, after talking with Crystal’s Tech Support, we figured out the answer. I was using the same Application Pool in IIS for both Crystal 10 web sites and Crystal XI R2 web sites. Once I created a second application pool for the applications that used Crystal XI R2, and assigned that pool to those applications, everything worked perfectly.