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]]
__
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
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
I have a client running Microsoft SQL Server. I am interested in ways of
accessing data from this server using R.
I would welcome any information about how this can be done. I have a
reasonable grasp of SQL and have experience with MySQL and RODBC but
don't know anything much about
David,
You can certainly use RODBC to get to MS SQL, once you configure the
ODBC connection in windows.
These days I tend to use RJDBC http://www.rforge.net/RJDBC/ which is a
bit less of a hassle.
Hint use the jtds driver http://jtds.sourceforge.net/
HTH,
Jim Porzak
Ancestry.com
San Francisco,
r-help-boun...@r-project.org wrote on 01/25/2010 03:32:41 PM:
Jim writes to David:
These days I tend to use RJDBC http://www.rforge.net/RJDBC/ which is a
bit less of a hassle.
Hint use the jtds driver http://jtds.sourceforge.net/
...
I have a client running Microsoft SQL Server. I am
6 matches
Mail list logo
