Kbase P116604: System error 6177 after changing the ODBC DSN and ODBC driver from SQL Server to DataDirect
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/9/2006 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
System error 6177 when executing query
SYSTEM ERROR: Assignment error. (6177)
The following error displays right after the system error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value 'field_name' to a column of data type int.
The ODBC DSN and ODBC driver have been changed
The ODBC DSN still points to the same MS SQL Server database
The Schema Holder has been created with the MS SQL Server ODBC Driver
Connecting with the ODBC driver for MS SQL Server shipped with the Progress/OpenEdge installation.
CAUSE:
When changing the ODBC DSN and the ODBC driver, the schema holder should be recreated.
Depending on the ODBC driver specified, the internal code of the DataServer for MS SQL Server is different.
FIX:
The DataServer schema needs to be recreated.
Before recreating the DataServer schema, delete the current DataServer schema from Data Administration (DataServer -> MS SQL Server Utilities -> Delete DataServer Schema...).