Hi all,
Problem is solved.
The solution is I needed to pass the whole string "driver=SQL Server;server=
01hd166373" as a parameter and not only the servername.
my<-function(servername,dbname,dbtable){
library(RODBC)
channel<- odbcDriverConnect(paste(servername)
init_data<- sqlQuery(chan
Dear R experts,
I am using RODBC package.
library(RODBC)
channel<- odbcDriverConnect("driver=SQL Server;server=",servername)
data<- sqlQuery(channel,"select * from dbname .. dbtable")
Here if i use this it is getting executed successfully.
But when i put this in a function as
my<-function(serv
2 matches
Mail list logo