Unanswered: Problems getting data using linked server
I am using SQL server 2000 with SP3 with SQL_Latin1_CP1_CS_AS as char set. I created linked servers to get data from sybase ASE (220.127.116.11).For sybase, we were using iso_1 char set and now we are changing it to cp850(in syabse).
We have some german characters in our sybase database.
After this char set change, when I try to get data from one of my views(with german characters), I dont get correct data rather I get some junk chars in place of those german chars.
If I use iso_1 for sybase, I get correct data.
In Linked server properties, I am setting remote collation to true.