Monday, February 20, 2012

Linked Server to AS400 via ODBC Codepage Problem

Hi!
I am connecting to an as400 server (v5r2) from my sql 2000 server
using the oledb provider for odbc. In the provider string i use:
Driver={iSeries Access ODBC Driver};System=myServer;DefaultLibraries
=QG
PL;QUERYTIMEOUT=0;CCSID=1253;UNICODESQL=
1;TRANSLATE=0;
which works fine with english data i try to retrieve. However
some of the data is in greek. All the greek data comes back intelligible.
the codepage on the as400 system is 37.
Could any one please help me?
Thank you all in advance.Well,
In America it's common that when something is illegible, we say "It looks li
ke Greek to me". So maybe they figured if you want it back in Greek, they w
ould just give you junk

No comments:

Post a Comment