What can cause the German error message: "Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert au_erhalb des g|ltigen Bereichs" to appear when creating a new repository?

0 Likes

Problem:

What can cause the German error message: "Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert au_erhalb des g|ltigen Bereichs" to appear when creating a new repository?

Resolution:

ANSWER
----------------------------------
Translated to English this error is

 

"Converting a string to datetime, the corresponding datetime value is out of range"


 


 

This can be caused by your regional language settings. To resolve this, the language settings for the SQL Server user account that you are using to connect to the databse must be set to English. This should be done using the SQL Server Enterprise Manager tool.

 

 

  • Expand a Server group, and then expand a server.
  • Expand Security, and then click Logins.
  • In the details pane, right-click the login to modify, and then click Properties.
  • In the Language list, on the General tab, click the new default language in which messages are to be displayed to the user.


You will also need to enable the region settings option for your System DSN.

 

 

  • Click CONTROL PANEL | ADMINISTRATOR TOOLS | DATA SOURCES (ODBC)
  • Select System DSN
  • Click configure
  • Click NEXT and enter Login ID and Password
  • Click NEXT, then click NEXT again
  • Check "Use regional settings when outputting currency, numbers, dates and times"
  • Click Finish


    You should also ensure that all the ODBC System DNS settings as well as the general security settings are set to "SQL Server Authentication".

    The recommended "Windows Authentication" option will not work correctly for a non-English setup.

     

     

Old KB# 23775
Comment List
Anonymous
Related Discussions
Recommended