I am working on an application that is developed in Visual Basic 6, and is using Seagate Crystal Reports 8 for reporting. The client wants the Database to be SQL Server 2005, however we have had some issues with our application and had to install SQLServer 2000 for the reports to work.

The issue was the "Physical Database was not found", and installing SQL 2000 fixed this problem.

Given that the client only wishes to use SQL2005, is there any way we can get these to work in conjunction without a code-base rewrite?

Thanks!