When updating a TRBOnet database to a newer version, you may receive the following error:
This occurs when the collation of one or more columns inside a table does not match the database's default collation.
How to Fix the Collation Conflict
1. Open the database in , right-click the database, and select .
2. Paste the following commands into the query window:
ALTER TABLE Devices ALTER COLUMN driver_name NVARCHAR(200) COLLATE DATABASE_DEFAULT;
ALTER TABLE Devices ALTER COLUMN name NVARCHAR(200) COLLATE DATABASE_DEFAULT;
ALTER TABLE Devices ALTER COLUMN name NVARCHAR(200) COLLATE DATABASE_DEFAULT;
3. Execute the query.
