similar to: RODBC Connections closed automatically in background

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