Home » RDBMS Server » Networking and Gateways » gateways error,help me~
gateways error,help me~ [message #255190] Mon, 30 July 2007 23:55
keelin
Messages: 3
Registered: July 2007
Junior Member
I conncected the mssql 7 through the gateway sucessfully,but i met a problem

Problem:
When there is chinese-language in some columns of the tables,
these fields of the column will show messy code.
(the messy code like this:"▓┘????")

I run this sentence:
select business_name from "keelin"@mylink;
(there is messy code in the business_name column)

the error shows:
ora-28500:connection from ORACLE to a non-Oracle system returned this message
[Transparent gateway for MSSQL]{SQL Status:00000,SQL Code:1271592}
ora-02063: preceding line from mylink

The MSSQL 7 collate:
SQL_Latin1_general_CP850_BIN
Windows 2000 Chinese
The Oracle 10G CHARACTER:
ZHS16GBK
Windows 2000 Chinese

plz help me,
thanks

[Updated on: Mon, 30 July 2007 23:56]

Report message to a moderator

Previous Topic: lsnrctl status Gives TNS-01150 and NL-00303
Next Topic: Error while using Oracle Transparent Gateways
Goto Forum:
  


Current Time: Thu Dec 08 12:41:34 CST 2016

Total time taken to generate the page: 0.10680 seconds