Various error messages are encountered when trying to use the software
Internal ErrorError Message: Must declare the scalar variable "@devName".TargetSite: Boolean CheckConn(System.Data.SqlClient.SqlException)DeclaringType: ECT.ECAD.DAL.SqlServerProjectAttributes: privateMemberType: Method
Internal ErrorError Message: Invalid object name '#ParentDevice'.TargetSite: Void ProcessResults(System.Data.OleDb.OleDbHResult)DeclaringType: System.Data.OleDb.OleDbDataReaderAttributes: privateMemberType: Method
Internal ErrorError Message: Object reference not set to an instance of an object.TargetSite: System.String get_Guid()DeclaringType: ECT.ECAD.API.ProjectAttributes: publicMemberType: Method
Internal ErrorError 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.RuntimeMethodHandleAttributes: privateMemberType: Method
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.
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.