Hi everyone, I'm obviously missing something simple here...
Trying to connect to an external db with RJDBC. (I can connect OK with ROLAP and with other java apps, eg dbVisualizer) JDBC call seems to work ok: > driverClass <- "net.sourceforge.jtds.jdbc.Driver" > classPath <- "C:\\Dwns\\jtds\\jtds-1.2.jar" > identifier.quote <- '"' > drv <- JDBC(driverClass, classPath, identifier.quote) > summary(drv) JDBCDriver name = JDBC driver.version = 0.1-1 DBI.version = 0.1-1 client.version = NA max.connections = NA > but attempting to connect gives: > dbURL <- "jdbc:jtds:sqlserver://xxxx.yyyy.com;DatabaseName=sunms" > con <- dbConnect(drv, dbURL, uid = "jporzak", pwd = "zzzz") Error in .local(drv, ...) : Unable to connect JDBC to jdbc:jtds:sqlserver://xxxx.yyyy.com;DatabaseName=sunms > where "xxxx", "yyyy", "zzzz" are changed to protect the innocent. note that the dbURL string is exactly what I use in dbVisualizer with success (using WinXP SP2, R 2.5.1, RJDBC 0.1-3) -- TIA, Jim Porzak http://www.linkedin.com/in/jimporzak ______________________________________________ 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.
