Hi,
I have tried to install.packages("RODBC"), but it balks:
Installing source package `RODBC'' ...
creating cache ./config.cache
checking for library containing SQLTables... no
configure: error: no ODBC driver manager found
ERROR: Configuration failed for package `RODBC''
What am I missing?
What and where should "SQLTables" be? In another package?
What should I tell my administrators to make an ODBC driver manager
available to me?
--christian
Dr.sc.math.Christian W. Hoffmann
Mathematics and Statistical Computing
Landscape Modeling and Web Applications
Swiss Federal Research Institute WSL
Zuercherstrasse 111
CH-8903 Birmensdorf, Switzerland
phone: ++41-1-739 22 77 fax: ++41-1-739 22 15
e-mail: christian.hoffmann_at_wsl.ch__prevent_spamming
www: http://www.wsl.ch/staff/christian.hoffmann/
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
>>>>> Christian Hoffmann writes:> Hi, > I have tried to install.packages("RODBC"), but it balks:> Installing source package `RODBC'' ... > creating cache ./config.cache > checking for library containing SQLTables... no > configure: error: no ODBC driver manager found > ERROR: Configuration failed for package `RODBC''> What am I missing? > What and where should "SQLTables" be? In another package? > What should I tell my administrators to make an ODBC driver manager > available to me?The configure script is looking for symbol SQLTables in one of the following libs: odbc odbc32 iodbc E.g. on Debian you can install package libiodbc2-dev. See also file README in the RODBC sources. -kh -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On Freitag, 22. Juni 2001 09:58 wrote Christian Hoffmann:> configure: error: no ODBC driver manager found > ERROR: Configuration failed for package `RODBC'' > > What am I missing?maybe you don''t have unixODBC on your machine. you can download it from: www.unixodbc.org or look in your distribution (as long as you use linux or *bsd) bye till -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On Fri, 22 Jun 2001, Kurt Hornik wrote:> >>>>> Christian Hoffmann writes: > > > Hi, > > I have tried to install.packages("RODBC"), but it balks: > > > Installing source package `RODBC'' ... > > creating cache ./config.cache > > checking for library containing SQLTables... no > > configure: error: no ODBC driver manager found > > ERROR: Configuration failed for package `RODBC'' > > > > What am I missing? > > What and where should "SQLTables" be? In another package? > > What should I tell my administrators to make an ODBC driver manager > > available to me? > > The configure script is looking for symbol SQLTables in one of the > following libs: > > odbc odbc32 iodbc > > E.g. on Debian you can install package libiodbc2-dev. > > See also file README in the RODBC sources.If you have a choice, use unixODBC as suggested there, as it is more powerful and better-supported than iodbc. The address in the README is I think old: www.unixODBC.org is current. -- 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 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> If you have a choice, use unixODBC as suggested there, as it is more > powerful and better-supported than iodbc.FWIW I found iODBC easier to setup (but even then needed an example from Fritz to really get it working). It is probably easier to compile too. It might be worthwhile adding simple examples for ~/.odbc.ini for both of these libraries. I''d be happy to contribute one for iODBC. -- According to the latest figures, 43% of all signatures are totally worthless. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._