Open .DB (Paradox)
Let me say it again: A DSN is **NOT** a database name. Please do study the RODBC manual, and ask no more really disrespectful questions here.
On Wed, 26 Oct 2011, Eder David Borges da Silva wrote:
Prof Brian Ripley,
Even the question of modifying the database name:
channel <- odbcConnect("E2D00007.DB")
Mensagens de aviso perdidas:
1: In odbcDriverConnect("DSN=E2D00007.DB") :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Nome da fonte de dados n?o encontrado e nenhum driver padr?o
especificado
2: In odbcDriverConnect("DSN=E2D00007.DB") : ODBC connection failed
Thanks,
2011/10/26 Prof Brian Ripley <ripley at stats.ox.ac.uk>:
On Wed, 26 Oct 2011, Eder David Borges da Silva wrote:
Prof Ripley, my problem is:
require(RODBC)
con0 <- odbcConnect('http://www.leg.ufpr.br/~eder/E2D00007.DB')
Mensagens de aviso perdidas:
1: In odbcDriverConnect("DSN=http://www.leg.ufpr.br/~eder/E2D00007.DB") :
?[RODBC] ERROR: state IM010, code 0, message [Microsoft][ODBC Driver
Manager] Nome de fonte de dados muito longo
2: In odbcDriverConnect("DSN=http://www.leg.ufpr.br/~eder/E2D00007.DB") :
?ODBC connection failed
con0
[1] -1 problem with drive ODBC....
Who said DSNs could be URLs ... and they are not the names of a database either. library(fortunes); fortune(14) applies.
thanks ?der 2011/10/26 Prof Brian Ripley <ripley at stats.ox.ac.uk>:
On Wed, 26 Oct 2011, eder at leg.ufpr.br wrote:
Dear member list, Appreciate your help, I need to open the file that is located in: http://www.leg.ufpr.br/~eder/E2D00007.DB This file is Paradox, but I could not open at the RODBC package, I want to import it to R.
Why not?
My OS is Windows 7 - 64 Bit Does anyone have a suggestion for such a task?
R has a 'Data Import/Export Manual', with many suggestions.
Thanks
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
-- 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
-- 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
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
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