>If I make this query for the column >names from my Windows laptop or from a Windows server, using odbcConnect() &
>sqlQuery(), I get the column names properly. However, if I run this via >unix, it will chop off part of the column name. (E.g., with "Time >Background Estimation (seconds)", it becomes "Time Background Estimation >(se", which is 30 characters long.) With an ODBC connection, between R and the database there sit: R > RODBC > (OSodbc) > DBMSodbc > DBMS. Your problem must be with the unixodbc driver. Have you tried the RODBC setting to query one row at the time (rows_at_time argument in odbcConnect command)? Prof. Ripley warns about the connection retrieving incomplete data when rat > 1, precisely because of driver issues. See pages 5-6 of the pdf. http://cran.r-project.org/web/packages/RODBC/RODBC.pdf Plan B: reduce the abstraction layers between R and the dbms. Can you connect directly (i.e. not via odbc)? Leo A. Salas, Ph.D. Senoir Scientist - Informatics Division PRBO Conservation Science 3820 Cypress Drive, Suite 11, Petaluma, CA 94954 Ph: (707) 781-2555 x334 www.prbo.org<http://www.prbo.org/cms/index.php> | Please follow PRBO on Facebook<http://www.facebook.com/home.php?#!/PRBOConservationScience?ref=search>! PRBO conserves birds, other wildlife, and their ecosystems through innovative scientific research and outreach. [[alternative HTML version deleted]] ______________________________________________ R-help@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.
