Josh, It sounds like part of your problem is that you're not reading all of the documentation. The first step is to _understand_ what an ODBC Manager is AND what it is supposed to be doing.
You have to configure your manager (among other things) before you can even begin to make a connection from R with (RODBC). Don't get discouraged. ODBC is beautiful thing! Further, I make connections with RODBC to postgresql databases all the time. It is possible, just be patient and read the docs. Jason On Tuesday 11 February 2003 01:48 pm, Joshua Gramlich wrote: > I'm actually looking at that exact page in the import/export manual > right now. I'm trying to install RODBC via CRAN, but I get this: > > ....blahblahblah... > checking for library containing SQLTables... no > configure: error: "no ODBC driver manager found" > ERROR: configuration failed for package 'RODBC' > > Delete downloaded files (y/N)? y > > Warning message: > Installation of package RODBC had non-zero exit status in: > install.packages("RODBC") > > > > I tried installing unixODBC, but that didn't seem to solve the problem. > > Thoughts? > > > > Josh > Chicago > > On Tue, 2003-02-11 at 15:31, John Fox wrote: > > Dear David and Joshua, > > > > One can also access PostgreSQL via the RODBC package. There's more > > information in section 4 of the R Data Import/Export manual, which is > > part of the R distribution and is also available on CRAN. > > > > John > > > > At 04:08 PM 2/11/2003 -0500, David Forrest wrote: > > >On 11 Feb 2003, Joshua Gramlich wrote: > > > > Is anyone using R with postgres? I'd like to do so, but cannot seem > > > > to find any reasonable explanation of how to do so. > > > > > > > > > > > > Joshua Gramlich > > > > Chicago, IL > > > > > >library(RPgSQL) # It isn't in an obvious place: > > > # http://lib.stat.cmu.edu/R/CRAN/src/contrib/Devel > > >db.connect() > > >db.ls() > > > > > >Dave, > > >-- > > > Dave Forrest (434)924-3954w(111B) (804)642-0662h (804)695-2026p > > > [EMAIL PROTECTED] http://mug.sys.virginia.edu/~drf5n/ > > > > ----------------------------------------------------- > > John Fox > > Department of Sociology > > McMaster University > > Hamilton, Ontario, Canada L8S 4M4 > > email: [EMAIL PROTECTED] > > phone: 905-525-9140x23604 > > web: www.socsci.mcmaster.ca/jfox > > ----------------------------------------------------- > > > > ______________________________________________ > > [EMAIL PROTECTED] mailing list > > http://www.stat.math.ethz.ch/mailman/listinfo/r-help > > ______________________________________________ > [EMAIL PROTECTED] mailing list > http://www.stat.math.ethz.ch/mailman/listinfo/r-help -- Jason W. Martinez, Graduate student Department of Sociology University of California, Riverside ______________________________________________ [EMAIL PROTECTED] mailing list http://www.stat.math.ethz.ch/mailman/listinfo/r-help