Hi, I am trying to extract data from a database with R in order to produce monthly statistics. I found in the R Website, the package RODBC, RSQLite and others ones which permit this kind of extraction. The database I want to be connected with is a SQLBASE 7.0 database. So, I would like to know if, using one of these package or another one, I could be able to connect with this type of database. I hope I would be understood. I am not a database specialist and, being french, my english is a little bit poor. Thanks for your response. Vincent Spiesser ------------------------------------------------------------------------- Ce message a ete scanne par l'anti-virus du Conseil General du Finistere. ------------------------------------------------------------------------- [[alternative HTML version deleted]]
You haven't told us your OS. SQLBase would appear to have a Windows ODBC driver, so RODBC should be usable. I doubt it any other solution is (and RSQLite works only with SQLite). On Fri, 8 Sep 2006, SPIESSER Vincent wrote:> I am trying to extract data from a database with R in order to produce monthly statistics. > > I found in the R Website, the package RODBC, RSQLite and others ones which permit this kind of extraction. > > The database I want to be connected with is a SQLBASE 7.0 database. > So, I would like to know if, using one of these package or another one, I could be able to connect with this type of database. > > > I hope I would be understood. I am not a database specialist and, being french, my english is a little bit poor. > > Thanks for your response. > > Vincent Spiesser-- Brian D. Ripley, ripley at stats.ox.ac.uk 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
The ODBC protocol is a widely used standard for accessing databases sources, especially under m$ windows. I think you can use RODBC for accessing your SQLBASE data, at least after some machine configuration... Antonio. 2006/9/8, SPIESSER Vincent <vincent.spiesser a cg29.fr>:> > Hi, > > I am trying to extract data from a database with R in order to produce monthly statistics. > > I found in the R Website, the package RODBC, RSQLite and others ones which permit this kind of extraction. > > The database I want to be connected with is a SQLBASE 7.0 database. > So, I would like to know if, using one of these package or another one, I could be able to connect with this type of database. > > > I hope I would be understood. I am not a database specialist and, being french, my english is a little bit poor. > > Thanks for your response. > > Vincent Spiesser > > > ------------------------------------------------------------------------- > Ce message a ete scanne par l'anti-virus du Conseil General du Finistere. > ------------------------------------------------------------------------- > [[alternative HTML version deleted]] > > ______________________________________________ > R-help a stat.math.ethz.ch 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. >
On 9/8/2006 9:53 AM, SPIESSER Vincent wrote:> Hi, > > I am trying to extract data from a database with R in order to produce monthly statistics. > > I found in the R Website, the package RODBC, RSQLite and others ones which permit this kind of extraction. > > The database I want to be connected with is a SQLBASE 7.0 database. > So, I would like to know if, using one of these package or another one, I could be able to connect with this type of database.I don't know SQLBASE, but I'm pretty sure there is no package that specifically supports that database. So what you need to do is to find out if SQLBASE supports ODBC connections. If it does, then you can use RODBC. If not, then you're probably out of luck. Duncan Murdoch> > > I hope I would be understood. I am not a database specialist and, being french, my english is a little bit poor. > > Thanks for your response. > > Vincent Spiesser > > > ------------------------------------------------------------------------- > Ce message a ete scanne par l'anti-virus du Conseil General du Finistere. > ------------------------------------------------------------------------- > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at stat.math.ethz.ch 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.
for RODBC you must make a connection SQLBASE first: For XP: control panel > Admin tools > Data sources > Add... You may have to install the SQLBASE ODBC driver first if it is not on the list. The rest should be easy just supply the connection name and details to RODBC. jab -- John Bollinger, CFA, CMT www.BollingerBands.com If you advance far enough, you arrive at the beginning.