KB94278007: ArtiosCAD - Error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

Summary

When saving files in ArtiosCAD, some of them return with the error: "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value".

Symptoms

When saving files in ArtiosCAD, some of them give the following error: "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value".

Solution

In case all clients report the error:

1. Logon to the SQL database.
2. Go to Security > Logins > Programmer.
3. Double-click to see the Properties.
4. Check if the default language is set to English. If this is not the case, change to English.
   
   If the language had been changed to another language than English, the date format would be interpreted in a wrong way. For e.g., a file with a revision date 2014-06-13 would return an error because '13' would be considered as a month, which can only be in the range 1 to 12.
5. Close the windows in the SQL database, log out and then save the file again.
6. In ArtiosCAD, open one of the files that caused the error.
7. Click Save. This will open the database dialog.
8. Click OK.

You should not get the error anymore on the client.

In case several clients point to the same database server but not all clients have the above mentioned error:

On the concerned client(s):

1. Go to Control Panel > Administrative tools > Data Sources (ODBC) or Data Sources 32 bit (in case of a 64bit OS) > System DSN.
2. Select ArtiosCAD > Configure. Go through the next steps until you get to the window shown below.
   
3. Make sure you enable the Change the language of SQL server system messagesto: check box in case 'English' is not the selected language.
4. Change to English and keep the toggle on.
5. Click the Finish button.
6. In the ArtiosCAD, open one of the files that caused the error.
7. Click Save. This will open the database dialog.
8. Click OK.

You should not get the error anymore on the client.