[R] RODBC Error

[Michael Greene]

Is there a specific issue with connections using the RODBC package?   
I am able to use the same DSN/ODBC configuration to connect to the  
database using Microsoft Excel's MS Query tool, and using other  
drivers from other OSes (Windows).

Do I have to reference the driver directly in the odbcDriverConnect?   
I tried re-making the DSN with a different name, that didn't work  
either.



On Oct 30, 2005, at 2:18 AM, Prof Brian Ripley wrote:

> On Sat, 29 Oct 2005, Michael Greene wrote:
>
>
>>
>> Hello,
>>
>> I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to
>> connect to a PostgreSQL server on the local network.  I can't tell
>> whether my problem is in R, or in ODBC setup.
>>
>
> These are ODBC error reports, so the problem is in ODBC.
>
>
>> I got drivers from OpenLink, created a dsn and tested it using the
>> iODBC application.  then I load the RODBC package, use this code and
>> get the following error.  I tried with both the odbcConnect util and
>> the odbcDriverConnect util.  I am able to connect to the database
>> through other non-odbc based database programs from the Mac, so I
>> know it's not a Postgres setting (like no tcp/ip connections or
>> something).
>>
>
> No, you don't.  I've see quite a few problems which were Postgresql  
> (sic) settings affecting the ODBC driver.
>
>
>> > library(RODBC)
>> > channel <- odbcConnect("nfl",uid="postgres", pwd="xxx")
>> Warning messages:
>> 1: [RODBC] ERROR: Could not SQLDriverConnect
>> 2: ODBC connection failed in: odbcDriverConnect(st, case = case,
>> believeNRows = believeNRows)
>> >
>> > channel2 <- odbcDriverConnect(connection="DSN=nfl, UID=postgres,
>> PWD=vladdy79" )
>> Warning messages:
>> 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver  
>> Manager]
>> Data source name not found and no default driver specified. Driver
>> could not be loaded
>> 2: ODBC connection failed in: odbcDriverConnect(connection =
>> "DSN=nfl, UID=postgres, PWD=xxx")
>>
>
>
> -- 
> 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
>