Hi Simon,
Now I am able to connect my SQL Server2000 from R using RODBC as you told me in the last line of your mail. Thanks a lot to you Simon for helping. Now I feel better than before. J Cheers!! BS -----Original Message----- From: Simon Urbanek [mailto:simon.urba...@r-project.org] Sent: Thursday, August 06, 2009 10:40 PM To: bed.si...@oracle.com Cc: r-help@r-project.org Subject: Re: Help ::Not able to Connect R to SQL Server 2000 On Aug 6, 2009, at 10:36 , bed.si...@oracle.com wrote: > Hi Simon, > > I am using the R 2.9.1 with Window XP. > I have one query related with R to the database. I have successfully > connected R to MS-Access. > But when I tried to connect R to SQL Server 2000 then it throwing some class > not found error. > I tried the below script for R and try to connect to SQL Server 2000. > library(rJava) > library(DBI) > library(RJDBC) > drv<-JDBC("com.microsoft.jdbc.sqlserver.SQLServerDriver") > Error in .jfindClass(as.character(driverClass)[1]) : class not found > Can you please help me in this? Thanks to you. I suspect that you'll need to load the corresponding drivers. The message essentially tells you that the driver (class) you're trying to load is not known. I don't use Windows (and even less so SQL Server), so I'd suggest you search for JDBC and MS SQL Server and/or ask on the SIG-DB mailing list (although this is technically not an R question). With some luck there may be some MS SQL users on this list as well.. However, if you are on Windows, you may want to go directly to ODBC using RODBC instead of going through JDBC. Cheers, Simon [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list 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.
