Re: [R] RODBC Error

From: Michael Greene <mfgreene_at_bu.edu>
Date: Mon 31 Oct 2005 - 03:08:28 EST

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@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-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Mon Oct 31 03:26:51 2005

This archive was generated by hypermail 2.1.8 : Mon 31 Oct 2005 - 09:18:26 EST