I am trying to write a report in reporting services 2000 which access a sql server 7 database. It all workes fine with the connection and creating a dataset but I cannot seem to get the results displayed in the preview section. I get the following error:
"An error occured during report processing query execution failed for dataset XXXX DATABASEPROPERYEX is not a recognised function name "
Any help greatly appreciated
Your are running RS 2000 RTM - you have two options:
* install RS 2000 SP1 or SP2 on both the report server and the report designer machines. The service packs contain the fix.
* Alternatively, in report designer go to the "Data Options" tab of the "Dataset"
dialog. On the Data Options tab you will see that all settings contain "Auto" (and report server would therefore try to auto-detect the collation settings from the database server). Replace the Auto-settings with the following settings (e.g. if your SQL 7.0
database collation is "SQL_Latin1_General_CP1_CI_AS"):
Collation = Latin1_General
Case sensitivity = false
Kanatype sensitivity = false
Width sensitivity = false
Accent sensitivity = true
-- Robert
