Error or Warning Message

Various error messages are encountered when trying to use the software

Internal Error
Error Message: Must declare the scalar variable "@devName".
TargetSite: Boolean CheckConn(System.Data.SqlClient.SqlException)
DeclaringType: ECT.ECAD.DAL.SqlServerProject
Attributes: private
MemberType: Method

When trying to copy a project

Internal Error
Error Message: Invalid object name '#ParentDevice'.
TargetSite: Void ProcessResults(System.Data.OleDb.OleDbHResult)
DeclaringType: System.Data.OleDb.OleDbDataReader
Attributes: private
MemberType: Method

Internal Error
Error Message: Object reference not set to an instance of an object.
TargetSite: System.String get_Guid()
DeclaringType: ECT.ECAD.API.Project
Attributes: public
MemberType: Method

When opening a page or trying to use Modify Page

Internal Error
Error Message: Exception has been thrown by the target of an invocation.
TargetSite: System.Object _InvokeMethodFast(System.Object, System.Object[], System.SignatureStruct ByRef, System.Reflection.MethodAttributes, System.RuntimeTypeHandle)
DeclaringType: System.RuntimeMethodHandle
Attributes: private
MemberType: Method

Explanation

These error messages occurred after migrating a database to a SQL Server with a case-sensitive collation. The project database requires a case-insensitive collation.

How to Avoid

Install a SQL Server instance that uses a case-insensitive collation and create the project database or restore the database backup in that instance. The SQL_Latin1_General_CP1_CI_AS collation is known to work fine.