OraFAQ Forum: Networking and Gateways » gateways error,help me~

Home » RDBMS Server » Networking and Gateways » gateways error,help me~

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 09 09:52:10 CDT 2025