ORA-28500: Connection From ORACLE To A Non-Oracle System Returned This Message: C (Doc ID 2325424.1)

好记忆不如烂笔头abc

于 2020-12-11 10:17:44 发布

阅读量2.1k

点赞数

分类专栏： sqlserver oracle

原文链接：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=394817383674272&id=2325424.1&_afrWindowMode=0&_adf.ctrl-state=udisf04bf_374

版权

oracle 同时被 2 个专栏收录

433 篇文章

订阅专栏

sqlserver

31 篇文章

订阅专栏

本文介绍了解决使用Database Gateway for ODBC连接PostgreSQL数据库时遇到的ORA-28500错误的方法。该错误由字符及语言设置问题引起，通过在DG4ODBC init.ora文件中添加特定配置可以解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-28500: Connection From ORACLE To A Non-Oracle System Returned This Message: C (Doc ID 2325424.1)

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

SYMPTOMS

When using Database Gateway for ODBC (DG4ODBC) to connect to a Postgresql database using a Postgres ODBC connection the following error is encountered:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
c

CAUSE

The issue is caused by a problem with character and language settings.

SOLUTION

Add the following to the DG4ODBC init.ora file:

HS_NLS_NCHAR=UCS2
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1