Displaying 7 results from an estimated 7 matches for "odbcdatasources".
2007 Sep 27
2
Connecting R to PostgreSQL via RODBC, on Windows
...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 m...
2011 Jul 17
1
ODBC MySql DB: sqlQuery empty
...|
+-----------------------------------------------------------------+
| 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(t....
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
...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)"
Exc...
2015 Feb 03
2
Problem with odbc connector with cdr
...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 no...
2009 Aug 28
2
RODBC: how to set the data-source?
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
2015 Feb 03
0
Problem with odbc connector with cdr
...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 inf...
2012 May 21
4
plz help. how to filter/group/sort data on mass data
...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 mess...