[R] RODBC Error - first argument is not an open ODBC Channel

[Gaurav Virmani]

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]]