[R] R and TeraData
Warren Van Camp
wvancamp at ebay.com
Tue Dec 4 22:59:36 CET 2007
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.
More information about the R-help
mailing list