we have been running VB 6 application that uses Crystal 8.5 on a group of Terminal Servers for about 5 years. These servers are near their sell by date and we have created a new test server with more memory to try and take the first step to replacing our old kit.
The existing and new servers both run Windows Server 2003 R2 SP2 and are 32bit.
The existing instructions I have say to install, VB5 runtime components, CR ActiveX viewer, CR 8.5 (complete install) and put %systemroot%\crystal into the Path environment variable.
I did all this as the adminstrator. I have checked against the existing servers and all looked fine.
The application and reports reside on another server in our network and are accessed from there by the working Terminal servers.
However when I run the VB application I get the 20599 - Cannot open SQL Server. If I open an existing CR report and try to look at the database connections I get Class Not Registered. I have done extensive searching on this and follwed virtually all recommendations however nothing appears to be working.
I've created a new report and was able to create both Oracle and SQL Server OLE connections from it. It looks like only the historical reports are causing the problem.
Does anyone have any advice on how to get old reports working in a new environment ?