[R] RJDBC connection help needed

Jim Porzak jporzak at gmail.com
Fri Sep 21 05:13:05 CEST 2007


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



More information about the R-help mailing list