From: Prof Brian Ripley (firstname.lastname@example.org)
Date: Tue 11 May 2004 - 06:55:39 EST
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", 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
> 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=
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
> Trace = 0
> TraceAutoStop = 0
> TraceFile =
> TraceLibrary =
> 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?
> Remail@example.com mailing list
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
-- Brian D. Ripley, firstname.lastname@example.org 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
______________________________________________ Remail@example.com 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
This archive was generated by hypermail 2.1.3 : Mon 31 May 2004 - 23:05:08 EST