>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]]

