ORA-28500: [ODBC Driver 11 for SQL Server]: Attempt to access a column "UtilizaMetrica_DescontoComerci" {42S22,NativeErr = 207} - Column +30 character

Question

I configure a Heterogenous Service from Oracle to access SQL Server using the ODBC Drive from Microsoft

It works, but some query in specific table return the right message for example:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Attempt to access a column 'UtilizaMetrica_DescontoComerci'. {42S22,NativeErr = 207}[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]

The right column 'UtilizaMetrica_DescontoComercial' has 32 characters, but truncate in the return message to 30 characters

Answer 1

It seems that OHS has a limitation on the length of a column name (30 characters).

Workaround is to shorten the name to an acceptable length by defining a shorter alias for that column or using a view to do the same thing.