New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

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

- Who are the top users of September? Discover them here!

- Check out the ESS Active Energy Management Blog now! 

- Join us on October 23rd for a live Panel session to discuss The Power of a Sustainable Ecosystem with Hervé Coureil, Chief Digital Officer of Schneider Electric and other great speakers. Register here!

SQL Server Implicit conversion from data type datetime to int is not allowed

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

Hotfix for DataBase Update Error

Tags (1)
Labels (1)
No ratings