An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100127/872f6bb3/attachment.pl>
Microsoft SQL Server and R
3 messages · Orvalho Augusto, Olga Lyashevska
RMySQL is for MySQL. MySQL is not MSSQL. There is not RMSSQL. So the best you have something to conneto MSSQL... RODBC or you may connect. Or as Jim point you use a java client to connect to MSSQL through RJDBC which you may use for example a free jDBC driver like jTDS. Caveman
On Wed, Jan 27, 2010 at 12:44 PM, Olga Lyashevska <olga at herenstraat.nl> wrote:
Hi David,
I have a client running Microsoft SQL Server. I am interested in ways of ? accessing data from this server using R.
Why don't you try RMySQL package? It works fine for me. ? ? ? ?[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
OpenSource Software Consultant CENFOSS (www.cenfoss.co.mz) SP Tech (www.sptech.co.mz) email: orvaquim at cenfoss.co.mz cell: +258828810980
Yes, checking it now, I see you are absolutely right. Sorry for this confusion. Cheers, Olga
On 27.01.2010, at 12:45, Orvalho Augusto wrote:
RMySQL is for MySQL. MySQL is not MSSQL. There is not RMSSQL. So the best you have something to conneto MSSQL... RODBC or you may connect. Or as Jim point you use a java client to connect to MSSQL through RJDBC which you may use for example a free jDBC driver like jTDS. Caveman On Wed, Jan 27, 2010 at 12:44 PM, Olga Lyashevska <olga at herenstraat.nl> wrote:
Hi David,
I have a client running Microsoft SQL Server. I am interested in ways of accessing data from this server using R.
Why don't you try RMySQL package? It works fine for me.
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
-- OpenSource Software Consultant CENFOSS (www.cenfoss.co.mz) SP Tech (www.sptech.co.mz) email: orvaquim at cenfoss.co.mz cell: +258828810980