[R] rodbc error

[Uwe Ligges]

So we'd had to debug either your code (which we do not have) or your 
database server (or its connection).

Hence we cannot so very much without the code or reproducible examples. 
Please also tell us the warnings you got when saying warnings().

Uwe Ligges



On 10.03.2011 16:51, Dr. Alireza Zolfaghari wrote:
> Hi list,
> I have code which reads data from sql server using RODBC in R version
> 2.12.1. The code used to be ok, till today when I get the following error.
> The data does not have any problem, but if I run the code in differnt pc, it
> runs till different number of trial then it fails, for example on one pc, it
> runs up to 30 times, other pc up to 66 times, then it fails. Any help
> please?
>
> [1] "so far 66 accounts out of 936 have been done!"
> Loading required package: RODBC
> Failed with error:  ‘subscript out of bounds’
> In addition: There were 50 or more warnings (use warnings() to see the first
> 50)
> Error in `[.data.frame`(mydata, , epcol) : undefined columns selected
>
>
> thanks
> Alireza
>
> 	[[alternative HTML version deleted]]
>
>
>
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.