[R] RODBC in RAqua

[Prof Brian Ripley]

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