Linked Server - Force Translate

From: Claude (Claude_at_discussions.microsoft.com)
Date: 02/20/05


Date: Sun, 20 Feb 2005 15:17:02 -0800

I have created a linked server using the "IBM DB2 UDB for iSeries for OLE DB
Provider" and query it with OPENQUERY. All numeric and date fields come thru
successfully however all text is returned as binary values. I had the same
issue when using a connection string with same provider which was resolved
when I set the Force translate to False.

How can I set the Linked server to not translate ?