Displaying 12 results from an estimated 12 matches similar to: "RODBC Connections closed automatically in background"
2009 Aug 21
3
Core dump gets created while accessing voicemail
Hi ALL,
When i was accessing the voice message it suddenly goes dead and after that
i couldn't able to retrieve the voicemessage again from my mailbox . This
happens once in a while for any configured mailboxes
I am using the following system configuration.
asterisk 1.4.22.1
odbc storage of voicemail messages
centos 5.2 64bit
unixODBC-2.2.11-7.1
mysql-connector-odbc-3.51.12-2.2
2000 Mar 08
0
RODBC: follow up
Hi Michael,
Here is the result of my first testing:
(0) Dr. Watson
Sorry, I should have given a more precise description: by default in R
exists a function with the name 'table', if you use this name as in
odbcPrimaryKeys(0, table)
a Dr. Watson occurs, because table does not give a table name.
However, it is always a good idea to prevent Dr. Watsons, even if it is
triggered by a
2004 Apr 02
1
convert excell file to text with RODBC package
Hi, i can convert excell to list in R with package RODBC ()but i don't
understand 2 mistake
1) Don't read the last row of the table excell
2) Don' t take the hours
My excell file call prueba4.xls and have the following rows:
where prueba4.xls was make in excell (office xp) and have one spreadsheet
call "Hoja1", you see each rows of she:
D??a Hora col1 col2 col3 col4 col5
2004 Nov 25
0
Problem with ODBC access to SQL database
I have the following problem in getting the "sqlSave" function from the
example code in the R package RODBC to work with MySQL as ODBC server:
- a new database is created, but no data is written to it
- the example code works just fine when I use MS Access as ODBC server.
----------- offending code and output -------------------
> library(RODBC);
> channel <-
2009 Jul 30
0
RODBC and Oracle
I just joined and though I did quickly read the posting guide it is quite possible not going to be a perfect posting. For one I tried to figure out how to reply to an existing message on the topic. I gave up but figured I keep at least the same subject.
In a gist I get an empty data frame after issuing the following select query from R 2.9.1 to Oracle 10.2.0.1 64bit via RODBC 1.3 and Oracle 11g
2001 May 14
1
RODBC: closing databases
Dear all,
platform i386-pc-mingw32
arch x86
os Win32
system x86, Win32
status
major 1
minor 2.3
year 2001
month 04
day 26
language R
I wrote the following to import tables in different database formats
(Access, Visual FoxPro, etc.):
getTable <-
2007 Jan 07
3
as.Date() results depend on order of data within vector?
Dear all,
The as.Date() function appears to give different results depending on
the order of the vector passed into it.
d1 = c("1900-01-01", "2007-01-01","","2001-05-03")
d2 = c("", "1900-01-01", "2007-01-01","2001-05-03")
as.Date(d1) # gives correct results
as.Date(d2) # fails with error (* see below)
This problem
2009 Aug 04
2
"na.strings" and the like; suspending interpretation of "NA"
Can someone point me to the proper place in the documentation or on the
Wiki where I can learn how to get R to stop interpreting the string "NA"
as something special? I have a table in a database which contains
(among other things) country codes and continent codes. The standard
set of two-letter codes includes "NA" to denote "North America". I
learned of the
2007 Apr 02
1
RODBC, sqlQuery with NA:s
Hi R-users,
I'm trying to retrieve data from MS SQL database with RODBC's
sqlQuery-function:
temp <- sqlQuery(channel,"select *, (select text from table1 where
koodi='paa' and koodi2=paa) as tempor from table2")
str(temp)
…
$ var0 : num NA NA 1.6 NA NA 1.4 NA 1 NA NA ...
$ var1 : Factor w/ 45 levels "
2006 Oct 17
2
RODBC and NULL values
Dear All,
Writing sooner than I thought I'd need to.
I'm using R 2.4 on Mac OS X, with RODBC, PostgreSQL 8.1 and Actual's
ODBC driver. I have all my data in Filemaker 8.5, but it is
automatically exported into PostgreSQL for analysis as Filemaker's ODBC
and JDBC access is awful, slow and has a tendency to crash.
I have disability data where for each patient there is a survival
2008 Jan 10
1
RODBC, postgresql on Linux
Dear all,
I facing pbs using RODBC library.
I'm working on a Linux (Ubuntu Gutsy) os, with R version 2.5.1.
I've got Postgresql 8.2.5 installed with the odbc-postgresql package.
I try to connect in a R session to a postgresql database using:
odbcConnect(dsn="thedatabasename",uid="theuser",pwf="thepasswd",case="postgresql")
I get a message error,
2012 Mar 14
3
Problem installing RMySQL package!
I am facing issues while installing RMySQL package on windows(32 bit) installation of R-Project.
I am getting the following warning messages.
Warning messages:
1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/i386/R CMD INSTALL -l "C:/Program Files/R/R-2.13.2/library" D:\DOCUME~1\nagga002\LOCALS~1\Temp\RtmpLZndlE/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1
2: In