Re: [R] RODBC does not like table names >11/12 characters [sqlFetch vs. sqlQuery]

2009-09-15 Thread Stefan Uhmann
Just in case sb. has the same problem, using sqlQuery instead of sqlFetch solved the problem for me with RODBC 1.3-0. Seems as the implementation of sqlFetch does something bad to long table names - just a guess. Stefan Stefan Uhmann schrieb, Am 14.08.2009 14:12: Hi List, I used to access a

[R] RODBC does not like table names >11/12 characters

2009-08-14 Thread Stefan Uhmann
Hi List, I used to access a Paradox database using RODBC, but since last week I am not able anymore to fetch any table which has a name longer than 11 or 12 characters. Here is the the pattern of my code, nothing spectacular: library(RODBC) channel2<-odbcDriverConnect('DSN=xxx') #table names