similar to: Pb with RODBC installation

Dear R-users! I am using R 1.7.0, under Windows XP; I also have Internet Explorer 6.0.2600.0000, Norton AntiVirus 7.60.926. Our firewall seems to want to "protect" me from downloading precompiled packages for Windows. When I try to download packages, like http://cran.at.r-project.org/bin/windows/contrib/1.7/RODBC_1.0-3.zip for example, I am not allowed to and get a message like this:

Hello List, I am trying to install RODBC package in a debian linux box but getting the following message. Can anyone help me to find what I am doing wrong here: $ R CMD INSTALL RODBC_1.0-4.tar.gz ### * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output... a.out checking whether the C compiler works... yes checking whether we are cross

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

Dear R-users, I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under windows. Say I have a table "testtable" (in an Access data base) with 3 columns and 1 row that looks like this: X Y Z 0012345 42 42,1 The columns are of these types: X - character, Y - Long Integer, Z - Decimal. I use RODBC to get these data into R: > library(RODBC) >

Hello there fellow R-users, I am using the RODBC functionality to query a database. I am trying to read in a columns of strings which have a character field lengths greater than 255. The data.frame that I recieve back from the RODBC query only contains the first 255 characters (the rest having been truncated). Any help on how to solve this problem would be greatly appreciated. Reagrds Wayne

Hello I want to handle R from a C/C++ project developped with Microsoft Visual C++.Net I put a multiproject solution,and one project is a win32 and dedicated for R manipulation; When I put in this project the example code from "Written R extension" 4.7 Handling R objects in C p39: #include <R.h> #include <Rdefines.h> SEXP ab; PROTECT(ab=NEW_NUMERIC(2)) ; .... I got an

Calling function "sqlFetch" in library(RODBC) and specifying a character string as 2nd argument, I get an error I don't understand: library(RODBC) channel <- odbcConnect("mydatabase.mdb", case="msaccess") sqlFetch(channel, "mytable") # this works fine tabname <- "mytable"; sqlFetch(channel, tabname) # this gives an error: # Error in

Dear R users, I am trying to connect R to data that is in a Access Database but I have problem with the construction of queries using special characters. I am using RODBC package. The following is working : > MyQuery<-paste("SELECT first( (DateHeure) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM Colonne_3 ") > Col3<-sqlQuery(con, query=MyQuery) > Col3

Hi, because wine 1.0 rc3 isn't available via yum (I'm using Fedora 9 btw.) I've installed it via Source-Code. In this case I downloaded it, run ./configure --verbose, followed by make depend, make and make install. It's installed and seems to run, but there is no entry in Applications. Have I forgotten to install something for that? best regarts Heinrich

You could construct your SQL statement as a character string using paste() and pass this as an argument to sqlQuery. Maybe something like this will work for you: >data1<-2.5 >sql.statement <- paste("SELECT * FROM somewhere WHERE something=", data1, ";", sep="") >library(RODBC) >channel <- odbcConnect(...) >sqlQuery(channel, query =

This is really a query about MySQL which I am trying to use to set up a database which I will then access with RODBC. I have my data in a .csv file, and some of the fields are date/time fields. I tried to create a table using mysql with the definition of the date/time field given by CallDate DATETIME, but I got an error saying that the first row has 28/07/2006 0:00 in that field. What I

Dear R-users, I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under windows. Say I have a table "testtable" (in an Access data base), which has many different columns, among them a character column "X" with "integer-like" data as "0012345". Using sqlFetch, I'd like to assure that column X is read in as a character variable. So what

Hi, I use Xen 3.0.3-1 on a Debian Etch with LVM to store my DomUs. I already exploit a Windows 2000 in a DomU but I can''t install a windows NT4 Server: I have a death of Blue Screen during the installation begining. Did someone test that scary NT4 DomU with success? I think NT4 need a disk driver but wich one? and how can I give it one? My last solution to test is: to convert a NT4

Hello, I think to have find a small pb with openssh when a Radius server is unreachable. I use radius authentication with pam my system-auth is the following auth [success=done auth_err=die default=ignore] /lib/security/pam_radius_auth.so try_first_pass debug auth [success=ignore auth_err=ignore default=ignore] pam_nologin.so file=/etc/raddb/radiusfailure auth

I have been trying to read some data from an Excel workbook without success. The workbook is in .xls format and has multiple sheets, one with the sheet name Data, which is the sheet I wish to read from. One complication is that the header row of this sheet is comprised of dropdown boxes. I tried what I normally would do plus some variations. Here is the output. > require(RODBC) >

Hello, I get some problem installing asterisk + ekiga on my debian etch: ii asterisk 1.2.13~dfsg-2 Open Source Private Branch Exchange (PBX) ii ekiga 2.0.3-4 H.323 and SIP compatible VOIP client $: asterisk -U asterisk -vgc give me some WARNING like : ,---- | WARNING[21806]: res_musiconhold.c:852 moh_register: Unable to open | pseudo channel for timing... Sound

I have a problem with some missing headers when trying to install RODBC on my linux box. > install.packages("RODBC", + lib="/usr/local/david/R") trying URL 'http://cran.stat.auckland.ac.nz/src/contrib/RODBC_1.3-1.tar.gz' Content type 'application/x-gzip' length 990220 bytes (967 Kb) opened URL

Hi, i'm trying to read some data from excel files but it seems that neither xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). When i open the file in Excel and save it in a new format Excel 97 -2003 everything works fine. Is it possible to use ODBC connection to open old format files, or i guess i will have to open and save every file in Excel in new format, which

The RODBC installation failed, with the following message ( 2 missing c header files ): checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ‘RODBC’ * removing ‘/home/hadoop/R/i686-pc-linux-gnu-library/2.15/RODBC’ Warning in install.packages :   installation of package ‘RODBC’ had non-zero exit status The

I have tried to install the RODBC package with the next command: > install.packages(("ORDBC"), (lib="usr/lib/R/library")) But it is failed. Can I get some information about the installation of this package anywhere? Best regards, Nader -------------------------------------------------------------- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html