[R-sig-DB] Open .DB (Paradox)

[Prof Brian Ripley]

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 using stats.ox.ac.uk>:
>> On Wed, 26 Oct 2011, eder using 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 using r-project.org
>>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>>
>>
>> --
>> Brian D. Ripley,                  ripley using 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 using 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