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

[Prof Brian Ripley]

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