What are the challenges you face when working across database platforms? Take the survey
Options

Report Viewer : Unable to generate report

jloosfeltjloosfelt Posts: 2
edited July 30, 2007 1:02PM in SQL Backup Previous Versions
When I try to view a report using the Tools/Reporting functionnality, I create a database to have a multiple server report.
The "update server history" task works fine. But in the next step Report Viewer shows an error :"Unable to generate report":
An error occured while generating the report. The message returned by SQL server was:
"La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors limite de date et d'heure."

Is it a bug due to the french setttings for SQL Server ?

Thanks for your answer !

Jeremie

Comments

  • Options
    Hi,
    It appears that the issue is indeed due to the french settings in SQL Server. The error you mention is easily reproducible in the following scenario:

    SET LANGUAGE FRENCH;
    SELECT CONVERT(DATETIME, '2006-03-30');
    GO
    SET LANGUAGE ENGLISH;
    SELECT CONVERT(DATETIME, '2006-03-30');

    The first generating the error message you mention, the second working correctly. The problem being due to the date format not being recognised correctly in the french language.

    I will investigate and see if there is a workaround for this in the meantime and get back to you, and will also raise this to be fixed in the next release of SQL Backup.

    Thanks,
    Jason
Sign In or Register to comment.