Skip to content

R and TeraData

2 messages · Warren Van Camp, Brian Ripley

Original
Warren Van Camp
#
Vadim Kutsyy wrote:
You indicate that the ODBC connection to Teradata on Windows is working for
you.  This may be a newbie question, but I'm not getting beyond an
apparently successful connection to the Teradata...
DBMS_Name               DBMS_Ver        Driver_ODBC_Ver 
            "Teradata"          "06.02.0205  V2R"             "03.52" 
          Data_Source_Name        Driver_Name             Driver_Ver 
             "ODW"                "TDATA32.DLL"          " 3.05.00.04" 
           ODBC_Ver                   Server_Name 
          "03.52.0000"               "********"
double integer    character      logical
MySQL                          double integer varchar(255)   varchar(5)
ACCESS                         DOUBLE INTEGER VARCHAR(255)   varchar(5)
Microsoft.SQL.Server            float     int varchar(255)   varchar(5)
PostgreSQL                     float8    int4 varchar(255)   varchar(5)
Oracle               double precision integer varchar(255) varchar(255)
SQLite                         double integer varchar(255)   varchar(5)
EXCEL                          NUMBER  NUMBER VARCHAR(255)      LOGICAL
DBASE                         Numeric Numeric    Char(254)      Logical
NULL
Error in typesR2DBMS[[driver]] : no such index at level 1
Error in iconv(data[[i]], from = enc) : invalid 'from' argument
In addition: Warning message:
closing unused RODBC handle 1
Error in iconv(query, to = enc) : invalid 'to' argument


Apparently there are some data conversion errors... do data types need to be
established first?  Any other ideas what's missing?

Thanks,
Warren.
2 days later
Brian Ripley
# 
I think that your first step should be to read the documentation of 
whatever software you are using here (you didn't say).

You are getting iconv errors because you set an invalid encoding.  You 
haven't shown us all the steps you used, and in one of those not shown you 
will find your error.  If you don't understand what they are needed for, 
at least at first accept the default arguments for things like encodings.

You will find people more willing to help you if you give them credit for 
their work: you are using a contributed package here without giving *any* 
credit, not even its name.
On Tue, 4 Dec 2007, Warren Van Camp wrote: