Hi,
Sincere apologies if my mail is inappropriate for this mailbox. Please
ignore the mail.
*Issue*
I am getting error "*first argument is not an open RODBC channel*" when I
publish my application on IIS. It runs perfectly under Visual Studio
development mode and the script runs fine on R
Just an update
This error can be reproduced with:
Windows system without MS Office (especially Excel) and an Excel file
with graphs inside a sheet. It does not depend whether this sheet is
used or not for import.
Knut
__
R-help@r-project.org
There is a system wide installation for the university computer of r and
Rcmdr (R-Commander)
There a a few computer with the following message the user tries to open
an excel sheet with R.Commander:
(I assume the german message is from the german operating system win 7)
library(RODBC,
When i am running a *DELETE * query on MS SQL database I am getting
*[RODBC] ERROR: Could not SQLExecDirect * error. I am getting this error for
the DELETE query that requires more time.
Please suggest workarounds if any.
Thanks
--
View this message in context:
This question might better be asked on r-sig-db or r-sig-mac (I am not
sure which one would better, but please not both).
-Don
--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
On 4/29/12 7:08 AM, julia.jacob...@arcor.de
Unfortunately, I'm not really making any progresses, despite a lot of effort.
I've compiled R on Mac OS X for myself using MacPorts and the error is now
state 28000, code 201 which is failed password authentification.
__
R-help@r-project.org mailing
I thought that maybe installing the RODBC package from source might fix the
problem:
install.packages(RODBC,type=source)
but to no success.
RODBC still gives the same warning with the same error code and very little
information to tackle the problem.
On Apr 25, 2012, at 10:03 AM,
Hello everybody out there using the RODBC package,
On my linux (unixODBC) and windows machines, I can successfully use the RODBC
package to connect to a PostgreSQL databse.
On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the
error code 202 and message ? when I try to
On Apr 25, 2012, at 10:03 AM, julia.jacob...@arcor.de wrote:
Hello everybody out there using the RODBC package,
On my linux (unixODBC) and windows machines, I can successfully use the RODBC
package to connect to a PostgreSQL databse.
On my Mac Book running Mac OS X 10.6 (Intel 64bit
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,)
On 20.12.2011 14:55, Mike Pfeiff wrote:
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'
be asking what is the proper way to return inside of a char
string?
-Original Message-
From: Uwe Ligges [mailto:lig...@statistik.tu-dortmund.de]
Sent: Tuesday, December 20, 2011 8:46 AM
To: Mike Pfeiff
Cc: 'r-help@r-project.org'
Subject: Re: [R] RODBC Error: 'getCharCE' must be called
.
Uwe ligges
-Original Message-
From: Uwe Ligges [mailto:lig...@statistik.tu-dortmund.de]
Sent: Tuesday, December 20, 2011 8:46 AM
To: Mike Pfeiff
Cc: 'r-help@r-project.org'
Subject: Re: [R] RODBC Error: 'getCharCE' must be called on a CHARSXP
On 20.12.2011 14:55, Mike Pfeiff wrote
So we'd had to debug either your code (which we do not have) or your
database server (or its connection).
Hence we cannot so very much without the code or reproducible examples.
Please also tell us the warnings you got when saying warnings().
Uwe Ligges
On 10.03.2011 16:51, Dr. Alireza
Hi list,
I have code which reads data from sql server using RODBC in R version
2.12.1. The code used to be ok, till today when I get the following error.
The data does not have any problem, but if I run the code in differnt pc, it
runs till different number of trial then it fails, for example on
Hi Everyone,
I am trying to install RODBC but I get the following error message
Error in library.dynam(lib, package, package.lib) :
shared library 'RODBC' not found
In addition: Warning message:
package 'RODBC' was built under R version 2.12.0
Error: package/namespace load failed for 'RODBC'
On Oct 18, 2010, at 5:23 AM, Paolo Agnolucci wrote:
Hi Everyone,
I am trying to install RODBC but I get the following error message
Error in library.dynam(lib, package, package.lib) :
shared library 'RODBC' not found
In addition: Warning message:
package 'RODBC' was built under R
Dear R-community,
After repeating the sqlSave-command 3 times on a dataframe (of size 13149
rows * 5 columns) to my MS-Access database I get the following error:
*Error in sqlSave(channel, eksport_transp_acc_2, transp_acc_scenarier, :
unable to append to table ‘transp_acc_scenarier’*
**
This
Let us see if it is a R issue.
Try this:
Read the CSV on Ms Access directly. It is an importation on MsAccess.
If you succeed we will check R then.
Caveman
On Sun, May 16, 2010 at 11:48 AM, Johan Lassen johanlas...@gmail.com wrote:
Dear R-community,
After repeating the sqlSave-command 3
Thank you so much for pointing on this obvious check of the MS Access
database! Inspired, I tried to import the csv-file directly into the MS
Access database and I encountered an Error saying (freely translated from
Danish) : Cannot find search key.
The MS Access database is in MS Access-2000
20 matches
Mail list logo