Hi,
Sincere apologies if my mail is inappropriate for this mailbox. Please
ignore the mail.
*Issue*
I am getting error "*first argument is not an open RODBC channel*" when I
publish my application on IIS. It runs perfectly under Visual Studio
development mode and the script runs fine on R Console too. But getting
error once published to IIS
*Code Snippet:*
library(RODBC)
conna <- odbcConnect("XXX",uid='sa',pwd='xxxxx')
coreKPI<-sqlFetch(conna,"vw_GetFields")
odbcClose(conna)
I have tried using odbcDriverConnect instead of odbcConnect and providing
complete DB string but still the issue. Also I have set the PATH variable
to point to 32 bit R. Tried few other options suggested on stack overflow
but no luck. I have been struggling for 3 days now to get this going.
Please advise.
Thanks in anticipation.
Warm Regards
Gaurav
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
