Re: Linked Server - Force Translate

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 23:36:18 +0000 (UTC)

Claude (Claude@discussions.microsoft.com) writes:
> At first I created it through Enterprise Manger.
>
> After your post, I created it with :
> exec sp_addlinkedserver 'JDE',
> '',
> 'IBMDA400',
> 'Betty',
> '',
> 'Protection Level=None;Force Translate=0;Cursor
> Sensitivity=3;Initial
> Catalog="";Transport Product=Client Access;Catalog Library
> List=JDFADAT;Default Collection="";Convert Date Time To Char=TRUE;Extended
> Properties="";SSL=DEFAULT;Provider=IBMDA400.DataSource.1',
> ''
>
> It seem to ignore the Force Translate=0 and still returns binary. Any
> suggestions ?

Not knowing DB2, so this translation business is pretty obscure to me.

Did you try OPENROWSET? I would not be surprised to learn that it
gives the same result.

Hm, what happens if you convert the binary data to varchar, as in

    select convert(varchar, 0x41424344) 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • Re: Mass loading SQL SERVER stored procedure
    ... in Query analyzer run: insert into testEXEC master..xp_cmdshell ... have error msg:String or binary data would be ... Robert Song ...
    (microsoft.public.sqlserver.clients)
  • Re: exec encoding
    ... the exec command returns the output of the program. ... The output of the program is binary data and the image is wrong. ... above command works if the format is xpm. ... http://www.deepsoft.com/ -- Web Hosting, with CGI and Database ...
    (comp.lang.tcl)
  • writing binary data to the file (DMO)
    ... How can I write binary data to the file using _only_ sql server. ... exec xp_cmdshell 'echo Sometextgoes here>> c:\myFile.txt' ...
    (microsoft.public.sqlserver.programming)
  • exec encoding
    ... the exec command returns the output of the program. ... The output of the program is binary data and the image is wrong. ... above command works if the format is xpm. ... image create photo -data ...
    (comp.lang.tcl)