The TeradataForum depends on cookies for its operation. Please refer to our Privacy page for details. By closing this banner or continuing to browse the TeradataForum website, you agree to the use of cookies.

Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 05 Sep 2012 @ 11:23:18 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Connect R to Teradata
From:   Edoardo Baldoni

Hi All,

I am an analyst and it's the first time I am dealing with Teradata and Relational Databases. I should connect R to Teradata in Windows 64-bit using VMware Player.

1) I install the VMware Player and run it with Teradata Studio Express 14

2) I install the ODBC driver and create a DSN?

3) I use "BTEQ" in the Gnome terminal, create a table and try to import a sample CSV file, as explained in, but I retrieve the following error:

          Teradata Load Utility Version
          TPT_INFRA: TPT05004: CLI error 224 in connecting session (function ConnectSession).
          MTDP: EM_NOHOST(224): name not in HOSTS file or names database.
          TDLOAD: TPT05535: Error: Failed to determine the optimal load protocol for the load job.

4) Whenver I try to connect R to Teradata using the function tdConnect("nameDSN"), I get the following error:

Warning messages:

1: In odbcDriverConnect("DSN=teradataDSN") : [RODBC] ERROR: state 28000, code 0, message [Teradata][ODBC Teradata Driver] Not enough information to log on

2: In odbcDriverConnect("DSN=teradataDSN") : ODBC connection failed

Can anyone help me in setting up the connection ?

Thanks a lot


  <Prev Next>  
Next> Last>>  
  Top Home Join Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 18 Jan 2016