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.  

 

Regards.

BS


	[[alternative HTML version deleted]]


