Hi!
I'm happy using RMySQL to access a number of MySQL databases and RJDBC to
PostgreSQL ones here, but now I do need to integrate data from SQL Server
10.00.1600.
To the best of my knowledge and after googling for a while, RJDBC is my best
option to access SQL Server databases from my Mac OS X 10.6.8 installation
running R version 2.15.1 (2012-06-22) --
Platform: i386-apple-darwin9.8.0/i386 (32-bit).
java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06-434-10M3909)
Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01-434, mixed mode)
I'm trying this in R...
> drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver",
> "/etc/enu/sqljdbc_2.0/sqljdbc4.jar")
> conn <- dbConnect(drv, "jdbc:sqlserver://hostname;integratedSecurity=true",
> "username", "password")
and getting this exception...
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect",
as.character(url)[1], :
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not
configured for integrated authentication.
ClientConnectionId:b62ebeb1-d6b3-47a0-8136-b86b352b4e41
Please, must I be able to access our SQL Server database by
modifying/correcting the connection line syntax or am I using a wrong
driver/method? If I must be able to connect, please, could you point me to some
documentation explaining how to configure this driver to use integrated
authentication? I can access this server/database without a glitch using
Navicat Premiun on the same Mac OS X box.
Thanks for your help!
Ricardo
--
Ricardo Rodríguez
Research Management and Promotion Technician
Technical Secretariat
Health Research Institute of Santiago de Compostela (IDIS)
http://www.idisantiago.es
Nota: A información contida nesta mensaxe e os seus posibles documentos
adxuntos é privada e confidencial e está dirixida únicamente ó seu
destinatario/a. Se vostede non é o/a destinatario/a orixinal desta mensaxe, por
favor elimínea. A distribución ou copia desta mensaxe non está autorizada.
Nota: La información contenida en este mensaje y sus posibles documentos
adjuntos es privada y confidencial y está dirigida únicamente a su
destinatario/a. Si usted no es el/la destinatario/a original de este mensaje,
por favor elimínelo. La distribución o copia de este mensaje no está autorizada.
See more languages: http://www.sergas.es/aviso_confidencialidad.htm
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
