Home » RDBMS Server » Networking and Gateways » gateways error,help me~
gateways error,help me~ [message #255190] Mon, 30 July 2007 23:55
Messages: 3
Registered: July 2007
Junior Member
I conncected the mssql 7 through the gateway sucessfully,but i met a 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:
Windows 2000 Chinese
The Oracle 10G CHARACTER:
Windows 2000 Chinese

plz help me,

[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: Wed Aug 23 10:48:17 CDT 2017

Total time taken to generate the page: 0.04480 seconds