Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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

developer.teradata.com/..., but I retrieve the following error:

          Teradata Load Utility Version 14.00.00.04
          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

Edoardo



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2014 - All Rights Reserved    
Last Modified: 24 Feb 2014