search for: odbcdatasourc

...get it. how is one supposed to use R as a PgSQL client on Windows? Assume my windows desktop is on the same network as a PgSQL server, and I just need to use R to connect and pull down some data. The thing that is confusing me is that RODBC doesn't seem to know anything about PgSQL, in that odbcDataSources(type = "all") only returns info about MS/Excell/Access/dBase stuff. What does it take to get RODBC to deal with PgSQL? thanks, mike -- View this message in context: http://www.nabble.com/Connecting-R-to-PostgreSQL-via-RODBC%2C-on-Windows-tf4525842.html#a12913078 Sent from the R help...

...| +-----------------------------------------------------------------+ | information_schema | | +-----------------------------------------------------------------+ SQLRowCount returns 2 2 rows fetched ---4: GNU R TEST > library(RODBC) > odbcDataSources() MySQL-data "/home/me/opt/mysql-connector-odbc/lib/libmyodbc5.so" > t.con<-odbcConnect("MySQL-data") > t.con RODBC Connection 1 Details: case=nochange DSN=MySQL-data > sqlTables(t.con) # no output > sqlQuery(...

...nect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed After that as it suggested in R data import/export manual I installed AccessDatabaseEngine.exe. Also I used ODBC in c:\Windows\SysWOW64\odbcad32 to create data source called result. I check if it is created: > odbcDataSources() dBASE Files "Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)" MS Access Database "Microsoft Access Driver (*.mdb, *.accdb)" E...

...g ini files, I believe I need these to be under /etc/ instead of /usr/local/etc/, but I'm unsure about how to change those permanently. # odbcinst -j unixODBC 2.3.2 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini SQLULEN Size.......: 4 SQLLEN Size........: 4 SQLSETPOSIROW Size.: 2 Odbcinst does see the connection, it reads it from /usr/local/etc/odbcinst.ini. # odbcinst -q -d [MySQL] I tried copying my connection information onto those files listed above and I'm...

Hello, I want to try to connect R to PostgreSQL. I have found that there are three ways: DBI or RODBC or RPostgreSQL. I tried around with DBI and RODBC but didn't get it running. In both cases I'm not clear about how to set the driver/data source. I get this error: x > channel <- odbcConnect("rtest", uid="oliver") x Warning messages: x 1: In

...e to be under /etc/ instead of /usr/local/etc/, but I'm unsure > about how to change those permanently. > > # odbcinst -j > unixODBC 2.3.2 > DRIVERS............: /usr/local/etc/odbcinst.ini > SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini > FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources > USER DATA SOURCES..: /root/.odbc.ini > SQLULEN Size.......: 4 > SQLLEN Size........: 4 > SQLSETPOSIROW Size.: 2 > > Odbcinst does see the connection, it reads it from > /usr/local/etc/odbcinst.ini. > # odbcinst -q -d > [MySQL] > > I tried copying my connection i...

...ar ) FROM sales1) -------------------------------------------------------------------------- now, I must solve it using R ( I need stepwise analysis capability in further ). I have retrive data from database as below: ---------------------------------------------------------------- library(RODBC) odbcDataSources() conn=odbcConnect("sqlsvr") result=sqlQuery(conn,'select * from sales') odbcClose(conn) result -------------------------------------------------------------- But I dont' know how to process next step, such as filter,sort,group please give me some help. -- View this me...