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

[Eder David Borges da Silva]

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 using 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 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