Issue
An update from 1.94 to 1.94 SP1 will generate an "Installation error! Microsoft ODBC SQL Server Driver SQL Server Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query."
Product Line
Andover Continuum
Environment
- Continuum
- Windows XP
- Windows 7
- Windows Server 2003
- Windows Server 2008
Cause
A column in the db doesn't get converted properly SQL Server Implicit conversion from data type datetime to int is not allowed Use the CONVERT function to run this query.
Resolution
To correct this issue apply the following hotfix AFTER installing 1.94 SP1 but BEFORE running the database update
