Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Database update error "Installation Error! Microsoft ODBC SQL Server Driver SQL Server]Implicit conversion from data type datetime to int is not allowed. Use the CONVERT funct...

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

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

Hotfix for DataBase Update Error

Tags (1)
Labels (1)
No ratings
Version history
Revision #:
3 of 3
Last update:
‎2018-09-11 06:57 PM
Updated by:
 
Contributors