Re: [R] R connection with sql server 2005

2010-02-12 Thread vikrant
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

[R] R connection with sql server 2005

2010-02-11 Thread vikrant
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