Displaying 20 results from an estimated 2000 matches similar to: "RODBC problems"
2005 Aug 17
1
RODBC and sqlColumns
I have a Postgres database that I am connecting to with the Postgres
ODBC driver on Windows XP in R 2.1.0. In the database is a database
with two schemas (public and X). With RODBC (1.1-4) , I can connect to
the database and get the tables with sqlTables(db). I can query tables
in the schema with sqlQuery("SELECT * FROM X.test"). However, I can't
get the columns in table X.test
2002 Jul 18
2
RODBC and Excel Files
Hello,
I am trying to play with RODBC library and Excel Files. In my file
(doubs.xls) there are 2 spreadsheets:
> library(RODBC)
> connection<-odbcConnect("Excel Files")
> sqlTables(connection)
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1 F:\\Th?se\\R\\Doubs NA Faune$ SYSTEM TABLE NA
2 F:\\Th?se\\R\\Doubs NA Milieu$
2010 Nov 25
1
RODBC
Hi,
I am running the RODBC examples form the help guide. I am trying to
UPDATE a table in an Access data base but I am having an error.
library(RODBC)
library(termstrc)
path = getwd()
setwd(getwd())
dbName = "data.mdb"
pathdbname = paste(path,"/",dbName,sep="")
accesChannel = odbcConnectAccess(pathdbname, uid = "", pwd = "")
2003 Apr 04
2
sqlSave() Question
All,
I am new in R. I found sqlSave() doesn't work for our Oracle9i. The
following was the message:
> sqlSave(channel, USArrests, rownames="state")
Error in sqlColumns(channel, tablename) : USArrests : table not found on
channel
Check case parameter in odbcConnect
>
sqlQuery() works OK.
Please help. Thanks.
-MY
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
Hola Javier, si no estoy entendiendo mal, lo q deseo hacer no se trata de
configurar los parametros SQL, sino solo de colocar un vector en el
argumento VarTypes de la funcion sqlSave.
El manual especifica esa opcion, pero no da ningun ejemplo de como usarla.
*varTypes an optional named character vector giving the DBMSs datatypes to
be used for*
*some (or all) of the columns if a table is to be
2009 Mar 01
1
Temporary tables with Microsoft SQL?
I can create a temp table with MySQL and R DBI[1], but I don't see how
to do the same with Microsoft SQL 2005 and RODBC. R 2.8.1 creates the
table, but then it can never see it. I'm looking to avoid replacing
the convenience functions like sqlSave().
[1] https://stat.ethz.ch/pipermail/r-help/2009-March/190033.html
> library(RODBC)
> channel <-
2001 Mar 21
2
slow start-up
Dear all,
I'm working with R 1.2.2 on win98 (256Mb RAM) with ESS 5.1.18.
It happens that the start-up is very slow. I don't know exactly how to measure, but with a simple watch I recorded 15 seconds, while the startup of S+ 2000 (Sqpe+4 under ESS) takes around 3 seconds.
Tha fact is that sometimes it takes almost a minute (58.30 sec recorded) for the prompt to appear! And ESS gives me an
2000 Nov 14
2
library doubt
Hi all.
I'm trying to install the packages Rstreams and RPgSQL, but with no
success.
I did R INSTALL name package but if I try library(Rstreams) I get the
following error:
Error in library.dynam("Rstreams",pkg,lib):
dynamic library 'Rstreams' not found
Error in library(Rstreams): .First.lib failed
Where did I go wrong? I'm using R 1-1-1 on a Debian GNU/Linux box.
2010 Feb 23
1
RODBC to import/export xls files
Dear R users,
I've learned today about RODBC package in order to import xls file to
dataframes and export the dataframes to xls files.
However I have some problems. Please excuse me if these are basic but as
I said, I've just begun with this package.
Also this email is quite long, but everything is related, so I don't
think it would be better to split it. Moreover, there's a
2007 Nov 07
1
Dealing with schema in RODBC
Is there a way to get a table in a certain schema? The Oracle database I am
using has a table by the same name in two different schemas. This creates
problems in sqlUpdate because to sqlUpdate there are duplicate columns. The
following is part of the output of sqlColumns:
sqlColumns(eids, "TEST_ARTCL_INST")[,1:4]
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME
1
2002 Mar 20
1
RODBC under Windows
Hi,
I have been just playing with the ODBC connectivity under Windows. I have
never done this before and I thought I would go through some examples in
the "Data Import/Export" manual and learn how to setup data connections
while doing that. I ran into a small problem and I am not sure if this is
something I am doing wrong or a bug or, perhaps, a feature of the RODBC
package.
Here is
2005 Mar 15
1
RODBC, sqlSave and sqlAppend
Hi all,
I am currently trying to read, write and append data between R and MS access
using the RODBC library functions. I have no problems reading in the data
but when using sqlSave and sqlAppend it doesn't seem to work. I have made
sure that all the column names are sensible and there are no gaps etc in the
variables. My call looks like this:
sqlSave(channel,treatlist,test=F)
I've
2006 Jul 25
1
[RODBC] ERROR: Could not SQLExecDirect
Hi,
I've got a problem with RODBC and saving (sqlSave) of a dataframe in Access.
R 2.0.1 is running on windows XP.
When executing the examples in R help for the "USArrests" data set "sqlSAve" works fine, but running sqlSave() for a dataframe "Adat"
> str(Adat)
`data.frame': 1202 obs. of 18 variables:
containing 18 columns and ca. 1200 rows fails.
2007 Feb 20
2
RODBC problems with unixodbc
Hi,
I noticed that if a column is named "end" in a data frame (table.df
below), it leads to errors when trying to sqlSave()'it to a postgresql
connection:
---<---------------cut here---------------start-------------->---
con <- odbcConnect("PostgreSQL-DB", uid="user", pwd="password",
case="postgresql")
R>
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
2007 Nov 24
2
truncated fields with RODBC
I'm changing some functions from storing data in
SQLite (using RSQLite) to storing it in PostgreSQL
(using RODBC). When trying to store very long
character fields I get the following message:
> sqlSave(pg, Grids, rownames = FALSE, append =
TRUE)
Warning messages:
1: In odbcUpdate(channel, query, mydata, paramdata,
test = test, verbose = verbose, :
character data truncated in column
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
2003 Jul 21
1
RODBC: problem saving a new table in an "Excel database"
Hi
I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows
XP Pro. I am having problems writing a new table to an (Excel) database
using sqlSave.
I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I
believe, uses the Microsoft Excel Driver DSN). Then I try and save a new
table to the database(spreadsheet) using SqlSave, but obtain an error
message.
Below is
2003 Jan 29
1
RODBC sqlSave Error
Hi,
i get error after using a data.frame with subset for "sqlSave".
What can i do ?
It seems that lines like this in a data.frame structure are after subset
deleted and cause
the error ?
- attr(*, "variable.labels")= Named chr "CUSID" "Welle"
"Arbeitgeberfavorit1" "Aktuelle Bewerbungssituation" ...
..- attr(*, "names")=
2003 Apr 02
1
RODBC sqlSave problem.
Dear list,
Being new to both the postgres database, ODBC and the RODBC interface, I
am somewhat confused by some of the problems I am experiencing trying to
connect R to the database.
Whai I am trying is basically the example part of the help file for the
sqlSave function:
> library(RODBC)
> odbcConnect("theodor") -> channel
> data(USArrests)
> sqlSave(channel,