search for: db_prices

...te SAS server using SAS's 9.1 ODBC driver and the RODBC package. I'm running R-2.6.1 on Win XP. I can successfully connect to the database, but no matter which table I query, I get back an empty table with only the column headers. For example: > sqlQuery(con, "select * from PRICES.DB_PRICES") [1] COMMOD_CURVE START_DATE PRICING_DATE PRICE <0 rows> (or 0-length row.names) sqlTables also returns back an empty table: > sqlTables(con) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS <0 rows> (or 0-length row.names) And s...