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
______________________________________________
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.
