Slow Reports On Random Machines
I have some reports that run perfect on some XP machines, yet on other machines all reports run painfully slow and even creates locks on records (because its running so long).
We're using Crystal Reports 11.0 and our Server is running SQL 2000. I've tested running the reports as the same user on good and bad machines. I've also attemped to match installed software on both machine types. We have something like 5 working XP Pro and 5 non-working XP Pro machines. I'm at a loss.
I'm thinking this is somehow a ODBC issue, but I'm unable to resolve this and I'm unable to figure out what is the difference on the good machines.
Any troubleshooting tips would be appreciated.
Brian Dong replied
Have you searched both machines for crdb_odbc.dll? Do they match. I understand that both machines have a fresh copy of Crystal but I want to eliminate the possibility that something else may have installed part of the runtime on one machine.
The problem is definitely environmental since you've proven that by the queries each machine is generating. I'm leaning towards a difference in crdb_odbc.dll or possibly the SQL Server driver. I say this because the query the report generates is created by Crystal's database driver. In this case it's crdb_odbc.dll.
crdb_odbc.dll will check the ODBC driver to verify what syntax to use for things like Joins and so forth. This is why some users will see one query when the report is using SQL Server then change the report to use Oracle or Access or a different database and see completely different syntax.
It really is one of those two things that out of synch. To check the version of the SQL Server ODBC driver, go to the Windows Control Panel | Administrative Tools | Data Sources (ODBC) and click on the Drivers tab. You'll see all the drivers installed and the version. Compare the SQL Server drivers between the machines.