Re: [R] Problem reading PostgreSQL data with RODBC

2011-01-25 Thread Albin Blaschka
Am 24.01.2011 14:08, schrieb Bart Joosen: I think this is a problem with quotes. If you look good, you see: seiz.df<- sqlFetch(chnl, 'source.MAIN') ... 'source.main': table not found on channel You asked "MAIN", but your db can't find "main". If you use seiz.df<- sqlFetch(chnl, '\"source\".\"

Re: [R] Problem reading PostgreSQL data with RODBC

2011-01-24 Thread Bart Joosen
I think this is a problem with quotes. If you look good, you see: seiz.df <- sqlFetch(chnl, 'source.MAIN') ... 'source.main': table not found on channel You asked "MAIN", but your db can't find "main". If you use seiz.df <- sqlFetch(chnl, '\"source\".\"MAIN\"') , you problem should be gone.

Re: [R] Problem reading PostgreSQL data with RODBC

2011-01-23 Thread Phil Spector
Robert - If sqlTables() works, then R already knows the name of your database. Do you get a different result if you try seiz.df <- sqlFetch(chnl, 'MAIN') - Phil Spector Statistical Computing Facility

Re: [R] Problem reading PostgreSQL data with RODBC

2011-01-23 Thread stephen sefick
Are you using RPostgreSql package? I use this quite effectivly to interact with my database. HTH Stephen On Jan 23, 2011, at 10:48 AM, Robert W. Burn wrote: Dear list - I am having a problem using RODBC to access records from tables in a PostgreSQL database. There is no problem establish

[R] Problem reading PostgreSQL data with RODBC

2011-01-23 Thread Robert W. Burn
Dear list - I am having a problem using RODBC to access records from tables in a PostgreSQL database. There is no problem establishing the connection using chnl <- odbcConnect (dsn= ... etc. The DSN seems to be properly set up using the PostgreSQL Unicode ODBC driver, and sqlTables(chnl) works