Database Error: ODBC Error: SQL Server Error

[LebronJames]

I am converting version 7 report to a version 8.5 report. I am connected VIA ODBC and when I refresh the report I get the error Database Error: ODBC Error: and then when I click the Ok button I get: SQL Server Error

 

[synapsevampire]

Make sure that you use the CR supplied ODBC driver, not the MS one.

Also try opening the report and selecting Database->Set Location and point at the data source.

-k

 

[LebronJames]

I tried the Set Location and no difference. What do you mean use the CR ODBC driver, please elaborate..

 

[synapsevampire]

Do you know what ODBC driver you're using?

Crystal ships with it's own ODBC drivers, and suggests that you use them.

I assume that you're using a MS SQL Server database, but if you use another ODBC driver, you may get unexpected results.

You might make sure that it's using the right driver by selecting Database->Convert Database Driver and select

pdssql.dll

-k