How can we help you today? How can we help you today?

Report Viewer : Unable to generate report

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
jloosfelt
0

Comments

1 comment

Sort by
  • Jason Cook
    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
    Jason Cook
    0

Add comment

Please sign in to leave a comment.