1. Might be worthwhile to try out the "collation compatible" option for this linked server on the MSSQL side

2. Better to use the OLEDB provider (from Sybase, part of ther...