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 Consol
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 mailin
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, pos=
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:
http://r.789695.n4.nabble.c
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"
wrote:
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 li
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, julia.jac
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 ar
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
hin a string that is enclosed in double
quotes. It is correctly passed to the SQL interface.
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: R
e extra "\"' is improper SQL form.
Maybe I should 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:
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"'
sqlQ
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,)
c
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 Zol
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 on
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
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'
I
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 for
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 wrote:
> Dear R-community,
>
> After repeating the sqlSave-command 3 times on a dataframe
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 m
20 matches
Mail list logo