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.
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).
> 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")
Does anyone have any suggestions?
Thanks,
Michael Greene
RODBC Error
3 messages · Michael Greene, Brian Ripley
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
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