[R] RJDBC connection help needed

[Jim Porzak]

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