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 > > ______________________________________________ > [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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 ______________________________________________ [EMAIL PROTECTED] 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