Displaying 1 result from an estimated 1 matches for "chnl".
Did you mean:
chn
2011 Jan 23
3
Problem reading PostgreSQL data with RODBC
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 OK and produces a list of tables in the database (they are all in a schema called 'source'). But
> seiz.df <- sqlFetch(chnl, 'source.MAIN'...