Query Engine Error

[sanjig]

Hello,
I just upgraded Crystal reports 7.0 to 9.0 and I am trying to run the report and it gives me the error:

Query Engine Error:'42000:[Microsoft][ODBC SQL Driver][SQL SERVER]@ODBCVER is not a parameter for procedure sp_sproc_columns.'

The report uses ODBC and report was running fine with version 7.0.Any help would be appriciated

munny

 

[techies]

Hi Munny,

Could you elaborate on this. Does your stored procedure have any parameters? How are you setting the datasource to the report?

4200 is an ODBC error code which means Syntax error or Access violation[\b]. Search for ODBC error codes in MSDN.

Hope this will help you.

Cheers,
Techi