On Wed, 26 Sep 2007, mfrumin wrote: > > hey all, > > I feel like I must be missing something rather plain, but I don't get it. > how is one supposed to use R as a PgSQL client on Windows? Assume my > windows desktop is on the same network as a PgSQL server, and I just need to > use R to connect and pull down some data. > > The thing that is confusing me is that RODBC doesn't seem to know anything > about PgSQL, in that odbcDataSources(type = "all") only returns info about > MS/Excell/Access/dBase stuff. What does it take to get RODBC to deal with > PgSQL?
This is an ODBC (not RODBC) issue. You need to install the PostgreSQL ODBC driver and use the 'Data Sources' applet in the Control Panel to set it up. Talk to your sysadmin about how (s)he installed PostgreSQL (or read the PostgreSQL documentation) if you need more help. -- 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 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
