Crystal Reports 7 can't access sql server 2000

[gacisa]

Since i updated sql server from version 7 to 2000, all the queries made with Crystal Sql Designer show the next message:
"xBase error: Could not open the file"
and after
Error 20533.
Crystal version is 7.

All the reports that based on .qry files is not running too.
If the queris have parameters, the query asks for them.

Why does it happen?
Thank you.

 

[kenhamady]

Can you create a new QRY against the database?
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[gacisa]

Impossible to create or execute any new qry.

Only if i make a new report without any qry file I get success.

On w98 with mdac 2.5 i have not this problem. I can make any qry against any source (in this case sqlsrv2000)

Only with w2000 pro or w98 with mdac 2.6 or higher i get this problem.

I think that is odbc.
On a w98-mdac 2.6, if i change the sqlsrv32.dll to the mdac2.5 version i can make the qry files!!!

Thank you by your attention.

 

[kenhamady]

Are you connecting the report via ODBC?
QRYs only work with ODBC. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/