Re: [R] RODBC in RAqua

About this list Date view Thread view Subject view Author view Attachment view

From: Prof Brian Ripley (ripley@stats.ox.ac.uk)
Date: Tue 11 May 2004 - 06:55:39 EST


Message-id: <Pine.LNX.4.44.0405102149590.19262-100000@gannet.stats>

Does any other driver work? See the comments in the RODBC README.

In particular, does a 7.2.5 driver really work with 7.4.2, and do you have
a functioning driver -- the bundled one used to do exactly this.

On Mon, 10 May 2004, Anthony Darrouzet-Nardi wrote:

> I've been trying to get RODBC working in RAqua. For my database,
> let's call it "mydb", when I enter
>
> odbcConnect("mydb")
> or
> odbcConnect("mydb", uid="postgres", pwd="secret"),
>
> RAqua thinks for about 10 seconds, then crashes.
>
> mydb is a PostgreSQL 7.4.2 database running on my machine (Mac OS X
> 10.3.3). I am using the pgsqlodbc 7.2.5 driver and the driver manager
> that comes built in to OS X 10.2 and later, which is some version of
> iodbc.
>
> I should point out that the utility "odbctest", a simple command-line
> ODBC compliant interactive SQL client, can successfully connect to my
> database with the ODBC connect strings DSN=mydb or DSN=mydb;UID=
> postgres;PWD=secret

Yes, but that doesn't ask the driver for its capabilities.

> The odbc.ini file generated by ODBC Administrator (an GUI tool that
> comes with OS X) looks like this:
>
> [ODBC Data Sources]
> mydb = PostgreSQL
>
> [ODBC]
> Trace = 0
> TraceAutoStop = 0
> TraceFile =
> TraceLibrary =
>
> [mydb]
> Driver = /usr/local/lib/psqlodbc.so
> Description = This is my database
> username = postgres
> password = secret
> servername = localhost
> port = 5432
> database = mydb
>
> How might I get this working?
>
> Anthony
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
>

-- 
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://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html


About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Mon 31 May 2004 - 23:05:08 EST