| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
