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