407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6703)

SQL - Datetime value out of range error when saving a quote

This information applies to :

Article ID
6703

Created/Updated
December 1, 2008

Category


Are you using the most current release of QuoteWerks?
Version 24.0 Build 4
Issue:

When using the Corporate Edition rehosted to SQL, a user attempts to save a quote and receives the error:

SQL Execute Error
QuoteWerks trapped error "Datetime value out of range on converting a char-type value to a datetime value (-2147217913)

Cause:

The default language of the database login account has been changed. In the known example of this error, the database was original set to use English and was set to use German after a restore.

Solution:

Reset the default language for the database login to the original language and the error should be resolved.

New Search