similar to: Issue with RODBC

Hi, I am setting up my R environment on windows 7 for the first time. I am not able to send emails from my R sessions. I am having problem in creating outlook com object to send emails. Same code works fine from my windows xp setup. Following is the code (If outlook is already running on PC) x <- outlook() mail <- x$CreateItem(0) Mail object is NULL in above case. If outlook is not

Hi James, Is your server name correct in the string below? Looks like you are using incorrect server name. If you don't give full server name, then the server has to be registered with ODBC management tool so that it can be picked up automatically. Regards, Alok From: James Mathew [via R] [mailto:ml-node+s789695n4699208h81 at n4.nabble.com] Sent: Wednesday, November 05, 2014 5:04 AM To:

Hello, I am not able to query Sybase IQ database from R using RODBC package. Check the below code R> sybaseiq.query <- function (sql, ..., as.is = FALSE) { connstr <- "Driver={Sybase IQ};UID=ajadhav2;PWD=*****;ServerName=PSGSESHR01A_IQ;CommLinks=SharedMemory,TCPIP{host=psgseshr01_iq.sg.csfb.com;port=3051}" chan <- odbcDriverConnect(connstr)

Hi, I am trying to query a Sybase database on my new windows 7 machine. I am using native sybase driver "Adaptive server Enterprise" following is example code conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is)

Hello, We are having some strange issues with RODBC related to integer columns. Whenever we do a sql query the data in a integer column is 150 actual data points then 150 0's then 150 actual data points then 150 0's. However, our database actually has numbers where the 0's are filled in. Furthermore, other datatypes do not have this problem: double and varchar are correct and do not

All, I think this is pretty basic but I couldn't find the answer in any source. I have just built my own R for Linux (amd 64). It runs well, but R thinks that it only has 80 characters or so of screen width. I log on with Putty to the box and can stretch it as large as I want. Is there a simple way to tell R to use more screen width when displaying? From whatami: OS RELEASE :

Hi, I am using sendmailR package to send mails from R. I am not able to make carbon copy work properly. If I specify multiple recipients in to field, then they all receive individual emails and not carbon copies My sample code is require(sendmailR) header <- list(cc="b.mali@abc.com") to <-

Caveats and disclaimers: I am quite happy to undertake self-teaching if directed to a relevant prior posting and welcome such direction. I have programming and statistical training/experience which I would characterize as Masters level. Thank you for reading and replying to this post. It is very much appreciated. ---begin problem description I have a large data set that I have imported to R

Dear R-helpers, When I use sqlQuery in the package RODBC, I cannot break the line, but have to write the entire SQL Query on the same line. Is this expected behaviour? It is definitely workable, but makes the queries a slightly difficult to read and edit. I'm using R 1.9.1 and RODBC 1.0-4 on Windows Server 2003 and querying a Sybase database. Best wishes, Mikkel

Hi, I'm trying to get data from a MS SqlServer database into R, using the RODBC package. The problem I've found is that numeric data from my sql queries is returned with only two decimal digits. After searching the docs, I think the problem comes from my sql numeric data having "float" type instead of "double", as I found the following: "Where possible

I just installed R on my 64 bit SUSE Linux system -- I compiled with the default x windows support on.. This may be a newbie question (apologies in advance)-- but how does this show up in X? I have SSH'd in to my box and set my display -- I can run xcalc OK -- but when I hit the R binary it just goes to the command line -- if does not give me an x-window. I suspect I need another

Hello, i would like import Data from Sybase DataBase to R-1.5.0 via RODBC. With this i get a connection without problems ! channel <- odbcConnect("ODBCName","LoginName","LoginPass") dataSybase <- sqlFetch(channel,"EPORT_XYZ") ,but when i try this i get a message error ? (Perhaps the _ is a problem, i know that's i.e. not usual to name

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

Dear R-fans, My database access package RODBC is now available on CRAN. For those who have never used it, odbc is a database and platform independant API which provides an SQL interface to a large number of database engines. The databases supported include not only SQL based RDBMS but also CSV files, foxbase, dBase, MSExcel etc. ODBC has been promoted mainly by Microsoft and this is where the

Dear R-fans, My database access package RODBC is now available on CRAN. For those who have never used it, odbc is a database and platform independant API which provides an SQL interface to a large number of database engines. The databases supported include not only SQL based RDBMS but also CSV files, foxbase, dBase, MSExcel etc. ODBC has been promoted mainly by Microsoft and this is where the

Hello, I want to try to connect R to PostgreSQL. I have found that there are three ways: DBI or RODBC or RPostgreSQL. I tried around with DBI and RODBC but didn't get it running. In both cases I'm not clear about how to set the driver/data source. I get this error: x > channel <- odbcConnect("rtest", uid="oliver") x Warning messages: x 1: In

As a java programmer, I'm having issue conceptualizing the following use case: Given an value, passed into a function, how do I pull out the lookup? Ie. A list of keys (key1, key2, key3) A list of values (val1,val2,val3) I want to write a function (or is there something built in?) such that Callit <- (thekey) { (magic happens here) Return value } Any ideas? Thanks a bunch!

Hi, Does anyone have experience using RJDBC library to write to Sybase datatable? The jdbc driver I am using is jConnect 6.0. I can successfully write into a new datatable, but have problem appending rows to existing one. It either complains "Table *** already exists" or simply overwrite the existing one. Here is the example. I am trying to append 'data' to the existing

Hi, I'm trying to get R connected to Sybase on a Linux machine. I'm relatively new to databases, particularly the connectivity side. Do I have to use RODBC and install ODBC support on the system (a huge pain with Sybase, as you have to install a scaled-down version of Sybase itself on the system to get it to work with ODBC), or can I somehow use DBI to do it. Other processes on the