When importing data through DBLoad into a new Microsoft SQL database, the following error may occur:
INSERT (error = 127, native code = 2627) message: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'ICUNIT_KEY_0' Cannot insert duplicate key in object 'ICUNIT'
This error is not evident performing the same procedure in an environment running another database engine such as Pervasive. This problem may be related to an incorrectly defined Sort Order or Collation Name in the setup of the Microsoft SQL database.
To correct this problem, do the following:
Set Sort order to Case Insensitive
Set collation name to Latin_general_bin