Re: Linked Server - Force Translate

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

  • Next message: Michael McCallum: "Re: Informix Ole DB 64 Bit" 
    Date: Sun, 20 Feb 2005 19:59:01 -0800

    Thanks Erland,

    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 ?

    "Erland Sommarskog" wrote:

    > Claude (Claude@discussions.microsoft.com) writes:
    > > 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 ?
    >
    > You can specify a connection string when you define your linked server,
    > see sp_addlinkedserver in Books Online for details.
    >
    > You can also use OPENROWSET and specify a connection string with it.
    >
    >
    > --
    > 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
    >

  • Next message: Michael McCallum: "Re: Informix Ole DB 64 Bit"

    Relevant Pages

    • Re: using VBA to insert records from access database to sql server
      ... I don't think you can specify a connection string *within* a query like ... My preferred solution to this kind of problem would be to use ODBC to link ... the Access MDB and the SQL Server table. ...
      (microsoft.public.access.modulesdaovba)
    • Hitting Sql Server Stored Procedure Breakpoint from ASP.NET app
      ... I am not able to stop at a stored procedure breakpoint in SQL Server from an ... ASP.NET application unless I specify a username and password in my connection ... different user in DB connection string. ... debugging rights in SQL Server? ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: sql express 2005 security
      ... Or...you can encrypt your connection string inside your app.config file like ... And, yes, this means that the user will be able to connect to the database ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
      (microsoft.public.sqlserver.security)
    • RE: arghh.. cant get .NET to connect to sql server
      ... When accessing the SQL Server, there are two authentication modes. ... specify the userid and the password in your connection string, ...
      (microsoft.public.sqlserver.security)
    • Re: bcp accent problem
      ... For -C you specify a code page, not a collation, as I recall. ... file is in the ANSI code page, specify -C ANSI or -C RAW. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
      (microsoft.public.sqlserver.tools)