Re: [R] R and TeraData

From: Warren Van Camp <vancamp_at_sonic.net>
Date: Tue, 4 Dec 2007 20:24:56 -0800 (PST)

Vadim Kutsyy wrote:
>
>
> Does anyone know a way to connect from R on Linux box to TeraData
> server? I can use ODBC connection on Windows box, but with amount of
> data I need (and prefer) to use large Linux box.
>
> Thanks,
> Vadim
>
>

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...

> odbcGetInfo(odw)

             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"               "********" 

> getSqlTypeInfo()
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

> getSqlTypeInfo("TDATA32.DLL")

NULL
> odw_driver <- odbcGetInfo(odw)
> getSqlTypeInfo(odw_driver)

Error in typesR2DBMS[[driver]] : no such index at level 1

> sqlTables(odw)

Error in iconv(data[[i]], from = enc) : invalid 'from' argument In addition: Warning message:
closing unused RODBC handle 1

> sqlQuery(odw,"select top 10 * from odw_prs_v.pool")
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.

-- 
View this message in context: http://www.nabble.com/R-and-TeraData-tf4642728.html#a14160501
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Wed 05 Dec 2007 - 04:30:40 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 07 Dec 2007 - 15:30:17 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.