Displaying 20 results from an estimated 29 matches for "odbcqueri".
Did you mean:
odbcquery
2008 Jul 23
2
Using RODBC to use SQL queries
Hello,
I am new to the RODBC package, but I have looked over the PDF as well as a few websites that go over the SQL language. I can connect to my database fine using
>channel<-odbcConnect("Oracle ODBC")
# then am prompted to enter my user id and password
After that I'd like to use the odbcQuery function and the SQL statement:
SELECT * FROM table_name WHERE SAMPLE_YEA LIKE
2008 Mar 18
1
odbcQuery , memory.size
Dear R cracks
I am trying to fetch 38 Tables from 38 ESRI Geodatabases through an ODBC
connection.
I stored the 38 channels in a list and the 38 tablenames in an other list.
With a
for(i in 1:38) .... sqlFetch(....) I try to read the tables into a third
list. But always after a certain amount of rounds (mostly 16) i get
Fehler in odbcQuery(channel, query, rows_at_time) :
Calloc konnte
2007 Jan 26
0
FW: reducing RODBC odbcQuery memory use?
New to R, sorry if one or either of these is an inappropriate list for a
question like this below; please let me know if this is a general help
question.
Jill Willie
Open Seas
Safeco Insurance
jilwil at safeco.com
-----Original Message-----
From: WILLIE, JILL
Sent: Thursday, January 25, 2007 2:27 PM
To: r-help at stat.math.ethz.ch
Subject: reducing RODBC odbcQuery memory use?
Basic
2008 Mar 03
0
reducing RODBC odbcQuery memory use?
1. Can I avoid having RODBC use so much memory (35 times the data size or more) making a data.frame & then .rda file via. sqlQuery/save?
2. If not, is there some more appropriate way from w/in R to pull large data sets (2-5GB) into .rda files from sql?
[R] reducing RODBC odbcQuery memory use?
From: WILLIE, JILL <JILWIL_at_SAFECO.com>
Date: Thu 25 Jan 2007 - 22:27:02 GMT
2002 Sep 04
1
Passing dynamic sql statement to RODBC functions
Hi,
Does anyone know how to pass dynamic sql statement to RODBC function
"odbcQuery()" or "sqlQuery()"?
eg.: under R session, I did:
>library(RODBC)
>channel<-odbcConnect(...)
>data1<-2.5
>data2<-5.0
I want to construct the INSERT sql statement using variables "data1" and
"data2" and pass this statement to odbcQuery() . Can I do this?
2010 Jan 24
0
Setting the value of max in calls to sqlGetResults
I have compiled and linked a 64 bit version of R (R 2.9.2) and the
corresponding unix ODBC 64 bit package
When issuing a SqlQuery, I get the following error
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
2010 Jan 24
0
Setting thevalue of max in calls to sqlGetResults
I have compiled and linked a 64 bit version of R (R 2.9.2) and the
corresponding unix ODBC 64 bit package
When issuing a SqlQuery, I get the following error
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
2005 Mar 21
0
Cdr_odbc asterisk 1.0.6
Asterisk Ready.
*CLI> -- Executing route("SIP/7408-02e3", "370263") in new stack
-- odbcquery: query=370263
> Query = 370263 : SQLcmd = select routing, ring_timer from ddi_pool
where ddi_inbound = '370263'
Urgent handler
> app_route: Query Successful!
-- Varname= 55
-- odbcquery: set route 721017101
-- odbcquery: set timer 15
2007 Aug 14
4
Import of Access data via RODBC changes column name ("NO" to "Expr1014") and the content of the column
Dear all,
I have some problems with importing data from an Access data base via
RODBC to R. The data base contains several tables, which all are
imported consecutively. One table has a column with column name "NO". If
I run the code attached on the bottom of the mail I get no complain, but
the column name (name of the respective vector of the data.frame) is
"Expr1014" instead
2006 Feb 27
4
prepared query with RODBC ?
Dear List,
Would anyone know how to perform prepared queries with ROBC ?
I had a shot with some of the internal (non-exported) functions of the package
but ended up with a segfault, so I prefer asking around before
experimenting further...
Thanks,
Laurent
2002 Sep 05
0
AW: Passing dynamic sql statement to RODBC functions
You could construct your SQL statement as a character string using paste()
and pass this as an argument to sqlQuery.
Maybe something like this will work for you:
>data1<-2.5
>sql.statement <- paste("SELECT * FROM somewhere WHERE something=", data1,
";", sep="")
>library(RODBC)
>channel <- odbcConnect(...)
>sqlQuery(channel, query =
2004 Apr 30
0
RODBC & MS SQL Server: repeated calls to sqlGetResults() problem
Dear list,
RODBC is mostly working very well on Windows XP talking to MS SQL Server.
However, when trying to retrieve a result set in repeated batches the first
batch returns results ok, but then subsequent calls return no data (see code
below). I tried setting believeNRows=FALSE both in odbcConnect() and in
sqlGetResults() but this doesn't appear to make any difference. Also
odbcFetchRows()
2005 May 23
0
App_odbcexec
Hello everyone,
I have just gone through the installation process to add commands ODBCexec
and ODBCquery to the extensions.conf. However I am receiving an error in
asterisk "No application 'ODBCquery' for extension (incoming,33,2)". I have
installed unixODBC-2.2.11 and myODBC 3.51. I have gone through the
instructions as per
2011 Dec 20
1
RODBC Error: 'getCharCE' must be called on a CHARSXP
I am trying to connect to an internal database and use the sqlQuery command to reduce and retrieve data using the following code:
channel <-odbcConnect("some_dsn", uid="", pwd="")
txt<-'SELECT Date, Region, Price FROM TableXYZ WHERE Type="Domestic"'
sqlQuery(channel, cat(txt,"\n"),errors=TRUE,)
close(channel)
However, I get the
2007 Jan 30
0
calloc bug in RODBC 1.1-7 and later?
I'm trying to load Affy Annotation data from an Access database into R using
RODBC. This has worked fine for quite some time. The bug seems to be
correlated to RODBC versions 1.1-7 and later.
Works fine: R 2.2.0 with RODBC 1.1-4; R 2.3.0 or R 2.4.1 with RODBC 1.1-6
Fails: R 2.3.1 with RDOBC 1.1-7; R 2.4.1 with RODC 1.1-7 or 1.1-8
Details
=====
This works fine:
Version 2.2.0
2014 Jun 30
1
Getting data from Table in RStudio
Hello,
I am new to R progaming and have just started using this program since last week. What i want to achieve is to use R to determine patterns in sales/ customer complaint etc. information located in a mysql database. I am not sure how to approach this or which technique i should use to do so. However, i had proceeded to add a dataset to RStudio using the following code:
library(RODBC)
2002 Aug 02
1
R to Oracle via RODBC
Howdy,
I'm trying to use R to access Oracle 8i using the RODBC package On Linux
Red Hat 7.3.
Specs
R version 1.51
Driver: Easysoft ODBC - Oracle driver
Driver Manager: unixODBC
I get the following error when trying to executing RODBC commands. Can
anybody give me pointers as to what I'm missing or doing wrong
> library(RODBC)
> channel <- ("DSNName")
>
2007 Sep 29
1
RODBC and Oracle
Hi WizaRds,
I'm experiencing a problem connecting to an Oracle 10g database via RODBC
(I'm getting this on Microsoft XP).
The same SQL queries via PL/SQL Developer work just fine, but when I pump the query through sqlQuery in RODBC then I get a data frame back with 0 rows.
I cut the query down alternating between PL/SQL and RODBC until I figured
that it's some kind of row limit or
2012 Aug 27
1
Querying sqlite through RODBC causes R to crash
Dear R-SIG-Debian,
while trying to query data from an SQLite database through RODBC on
Debian testing, R crashes with the following message:
library(RODBC)
con3 <- odbcConnect("test3")
# 'test3' being an ODBC datasource configured with SQLite3 driver,
# but the same happens with SQLite driver
sqlQuery(con3, "select * from test") # 'test' being any table
2000 Nov 15
1
RODBC
I saw in the R-digest a thread about RODBC.
1) I think that this package is *extremely* valuable : it fulfills a need
quite important in the case of iterative (e. g. periodic) analyses. No need to
periodically return to your data and re-dumping them ...
2) The current version has a serious bug if your datasets has missing numeric
values. M. Lapsley, the original author, is aware of it, but has