Displaying 1 result from an estimated 1 matches for "commlink".
Did you mean:
comlink
2012 Jul 30
1
why querying Sybase IQ using RODBC returns error ?
Hello,
I am not able to query Sybase IQ database from R using RODBC package.
Check the below code
R> sybaseiq.query <- function (sql, ..., as.is = FALSE)
{
connstr <- "Driver={Sybase
IQ};UID=ajadhav2;PWD=*****;ServerName=PSGSESHR01A_IQ;CommLinks=SharedMemory,TCPIP{host=psgseshr01_iq.sg.csfb.com;port=3051}"
chan <- odbcDriverConnect(connstr)
on.exit(odbcClose(chan))
if (length(list(...)) > 0)
sql <- sprintf(sql, ...)
x <- sqlQuery(chan, sql, as.is = as.is)
return(x)
}
R>
R>
R>
R> x <...