linked server, sql native and provider string

• guillermo roldan-412514

  Grasshopper

  Points: 22

  More actions

  March 7, 2007 at 4:31 am

  #171610

  Hello,

  I am trying to connect to teradata using SQL Server 2005 using new linked server, the unique conector that is in the list and it could go well is sql native client, i'm trying to use this but i am negative to do this;

  has anyone used this before??

  thanks  

• Scott Coleman

  One Orange Chip

  Points: 27452

  More actions

  March 8, 2007 at 7:04 am

  #693800

  We use a Teradata linked server with this definition:

  EXEC

  master.dbo.sp_addlinkedserver

      @server = N'TERADATA', 

      @srvproduct=N'<database>', 

      @provider=N'TDOLEDB.1', 

      @datasrc=N'<host IP>'

  EXEC master.dbo.sp_addlinkedsrvlogin 

      @rmtsrvname=N'TERADATA',

      @useself=N'False',

      @locallogin=NULL,

      @rmtuser=N'<user>',

      @rmtpassword='########'

  EXEC master.dbo.sp_serveroption 

      @server=N'TERADATA', 

      @optname=N'data access', 

      @optvalue=N'true'

• guillermo roldan-412514

  Grasshopper

  Points: 22

  More actions

  March 8, 2007 at 7:29 am

  #693806

  I have execute this and after this query

  select * from openquery (ess,'select  * from db_esp_etude._001_cible_LCA_200701')

  and he shows this

  Msg 7302, Level 16, State 1, Line 1

  Impossible de créer une instance du fournisseur OLE DB 'TDOLEDB.1' du serveur lié 'TERADATA'.

   

  On the other hand I have seen that SQL Server takes ODBC 64 bits and my provider of OLE DB Teradata is in ODBC 32 bits

• Scott Coleman

  One Orange Chip

  Points: 27452

  More actions

  March 8, 2007 at 9:40 am

  #693856

  The linked server definition I showed is from a 32-bit server.  I don't know if they have a 64-bit provider.