R fails to connect to teradata using RODBC.
Installed required packages/drivers on OS in ksh (pdksh)
> channel <- odbcDriverConnect("dsn=mytd;uid=tduser;pwd=passwd;")
In odbcDriverConnect("dsn=mytd;uid=tduser;pwd=passwd;") :
ODBC connection failed
> stat <- .Call(RODBC:::C_RODBCDriverConnect, as.character("dsn=mytd;uid=tduser;pwd=passwd;"), 994.9, as.integer(TRUE), as.logical(FALSE))
odbcDriverConnect() is higher level function with more steps after establishing the basic connection; which is the second call C_RODBCDriverConnect(). stat should be greater than 0.
*** caught segfault ***
address (nil), cause 'memory not mapped'
1: .Call(C_RODBCDriverConnect, as.character(connection), id, as.integer(believeNRows), as.logical(readOnlyOptimize))
1: abort (with core dump, if enabled)
2: normal R exit
3: exit R without saving workspace
4: exit R saving workspace
teradataR crashes R.
Any help connecting from R (ODBC or JDBC or teradataR) to TeraData ?
I would try JDBC connect on Linux
You actually need to compile RODBC with teradata to get this to work...try the following in R:
You may need to change your teradata directories if you have a different version on your system.
I know there are differences between the SLES and Redhat versions, but for ROBDC connectivity and teradataR, check also the following article for ideas; I recently figured out how to get things together under a SLES11 SP1 Teradata Express VM.