similar to: RODBC installation in debian

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

Hello: Using Redhat 7.3 and > version platform i686-pc-linux-gnu arch i686 os linux-gnu system i686, linux-gnu status major 1 minor 6.1 year 2002 month 11 day 01 language R I am trying to install the RODBC package.

I am compiling R 2.11.0 on a RHEL5.3 box using the following settings ./configure --with-readline=yes --enable-R-shlib=yes --with-x=yes --with-blas="-llibptf77blas -lpthread -llibatlas" --prefix=/usr/local/R-2.11.0 JAVA_HOME=$JAVA_HOME CPPFLAGS="-I/usr/local/unixODBC-2.3.0/include" I have compiled and installed unixODBC-2.3.0 (64-bit) in /usr/local and can connect to and

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"

All- Does anyone on the list have experience with building RODBC from source on a Linux box for use with DB2? I am using (all from source): R 2.0.1 unixODBC 2.2.9 RODBC 1.1-3 For example: [jcole]$ R CMD INSTALL RODBC_1.1-3.tar.gz 2> rodbc.log * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether

Hello I'm starting to use R on a Windows XP Pro machine which is not connected to the internet; I want to use database connection so I downloaded the file "RODBC_1.0-4.tar" from CRAN; this file is not accepted by the "Packages->Install Packages from local zip file" menu function of R!!! I would like to know why it doesn't work and if it's possible to get

Hello. I have found a number of posts/threads on this subject and remain unsuccessful to determine the solution. In brief, my situation is: 1. Running FreeBSD 4.9 Stable in x86 2. Installed, and running, R 1.8.1 3. Installed, and running, postgreSQL 7.4.2 4. Installed, and running, unixODBC 2.2.8 5. Failed, repeatedly, to install RODBC. The following is my error log: tsunami# R CMD

[ Disclaimer: Yes, I do know that RODBC is in a state of minor limbo as far as maintenance is concerned. But it is also useful, and used, which is why I hope that someone might apply the small change outlined below. ] The current version in CRAN's devel directories fails to build under R 1.6.1 (beta from Oct 27): chibud:/home/edd/RODBC# R CMD INSTALL . * Installing *source* package

Dear R Beginners, Experts and Users, I already asked this question on the R-sig-DB mailing list, but sadly didn't got a reply :-( . Keeping fingers crossed that I have more luck on the main R mailinglist :) . I'm trying to connect to a MySQl database via Gnu R using the RODBC interface. The conenction workes but I get an empty result string. Gnu R and the MySql DB are running on a 64 bit

Hi All, I'm getting the following error, could anyone help please? $ R CMD INSTALL RODBC_1.1-7.tar.gz * Installing *source* package 'RODBC' ... checking for gcc... gcc -std=gnu99 checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for

essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle") > sqlTables(essai)$ORESTE ... 1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA> 1316 <NA> ORESTE S_PROVENANCES TABLE <NA> 1317 <NA> ORESTE

Hello everybody out there using the RODBC package, On my linux (unixODBC) and windows machines, I can successfully use the RODBC package to connect to a PostgreSQL databse. On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the error "code 202" and message "?????" when I try to establish an connection by using >con <-

Anyone out there using Linux RODBC and unixODBC to connect to a Microsoft SQL server? If possible can someone post a sample .odbc.ini file? I saw a few discussions on the archives a few years ago, but no config file details were available. Thanks, Whit This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended

Dear list - I am having a problem using RODBC to access records from tables in a PostgreSQL database. There is no problem establishing the connection using chnl <- odbcConnect (dsn= ... etc. The DSN seems to be properly set up using the PostgreSQL Unicode ODBC driver, and sqlTables(chnl) works OK and produces a list of tables in the database (they are all in a schema called 'source').

I've used R for a couple of years on FreeBSD with few problems. Recently, a couple of the contributed packages seem to have difficulty finding symbols in the shared libraries. Currently, I'm running R 1.3.1 on FreeBSD 4.4. I've tried setting LD_LIBRARY_PATH to /usr/local/lib and some other things. The packages I've had trouble with are: Matrix 0.3.15 RODBC 0.8.3 RSPython 0.3

Greetings - After 20+ years of using SAS, for a variety of reasons, I'm using [R] for a bunch of things - while I'm getting a pretty good a handling [R] for script programming, and statistical analysis, I'm struggling with 'pulling data into [R]'. For reasons beyond my control, a number of the files I get sent to 'work with' are in Dbase format (*.dbf). For

Dear all, I'm trying to connect to an MSAccess database (ArcGIS personal geodatabase). I keep getting an error about the channel when using sqlQuery(). However, sqlTables() does not complain about the channel and lists all tables in the database. If I try sqlFetch(), then R crashes. I'm happy to hear suggestions on how to solve this. Best regards, Thierry > MDB <-

Fedora 10 R 2.8.1 I hope someone can tell me the meaning of error I received trying to install RODBC and how I can get around the problem. n.b. The error originally occurred then I was installing Rcmdr. I then tried to install RODBC separately and received the same error. checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no

Dear r-helpers! I have trouble reading data from an Oracle data base using RODBC Version 1.0-3, R Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME

Hi, I'm trying to get to grips with accessing my postgresql tables in R using RODBC. I have Mac OS 10.2.8 (Darwin 6.8) installed and R 1.8.0 installed from source and I have updated RODBC to 1.0-4. On the ODBC manager end, I am using OpenLink software's iODBC Administrator and I've set up a User DSN called "PostGRES" - odbctest suggests that this is functioning: >