search for: ajadhav2

Displaying 1 result from an estimated 1 matches for "ajadhav2".

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