Hi! ________________________________________ From: Prof Brian Ripley [[email protected]] Sent: 24 October 2012 14:20 To: Rodriguez Fernandez, Ricardo Julio Cc: [email protected] Subject: Re: [R-SIG-Mac] accessing SQL Server 10.00.1600
On Wed, 24 Oct 2012, [email protected] wrote: > 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. >> >> This really is a very specialized issue: JDBC access to SQL server. >> It is saying 'jdbc:sqlserver://hostname;integratedSecurity=true' is >> not supported. Can you not check a non-R JBDC client and ask on a >> JDBC forum? >> I do agree. My hope was to find somebody here that is using a similar configuration/environment to see how she/he has worked around this issue. I'll look for more help where you propose and keep this thread posted if I get any solution. Thanks! > > 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 > -- Brian D. Ripley, [email protected] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 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
