Re: [R] why RODBC on windows 7 with Sybase, returns garbage?

2014-11-04 Thread Alok Jadhav
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] [m

Re: [R] Sending carbon copy mails from R

2013-07-15 Thread Alok Jadhav
There was a small typo in my sendmail command. I was passing header=header instead of headers=header. This argument was accepted because of `...` argument which is not the last argument as one would except. A minor mistake caused me a bit of frustration. This issue is resolved now. Thanks everyone.

Re: [R] Sending carbon copy mails from R

2013-07-11 Thread Alok Jadhav
updated code pasted here. So I guess CC is not an option at all? In that case is there any other package that would be useful? require(sendmailR) to <- c("v...@abc.com") header <- list(cc=c("a...@abc.com")) x <- sendmail("t...@abc.com", to, "test", "testing", header=header,control=list(smtpServer=

[R] why querying Sybase IQ using RODBC returns error ?

2012-07-29 Thread Alok Jadhav
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.cs

[R] Why does RODBC driver returns garbage from Sybase server on new windows 7 machine?

2012-05-04 Thread Alok Jadhav
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")

[R] sqlite create new unique id

2012-02-20 Thread Alok Jadhav
Hi everyone, I am trying to insert a row in sqlite table with my own unique id. I want to create unique id using sqlite internal function last_insert_rowid() which returns the next max rowid of the table which is always unique. I tested this using sqlite and it works fine but when i run the same

[R] generic function body display

2010-03-11 Thread Alok Jadhav
I recently restructured my R project to make use of S4 class objects. I converted some of the functions to generic functions. If I type the name of the function i can see the body for non generic functions. I am not able to retrieve the code for Generic functions. It is very convinient for users t