Crystal 8 rpts - errors switching to SqlServer 2000

[kingRon]

We have a large number of Crystal reports that run against a Sqlserver 7.0 database, which will be upgraded to SQL2000.
When I changed the ODBC connection to point to a test database on the 2000 box, an error message about a syntax error pops up. nothing changed in the db that I can see.
Are there any known issues withe crystal 8 and sql2000??


Thanks for any help,

 

[kenhamady]

What is the exact message?
Can you create a new report against the new database?
Open the report in design mode and verify the database and see if it will run. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com