search for: sqlcolumns

Displaying 19 results from an estimated 19 matches for "sqlcolumns".

2005 Aug 17
1
RODBC and sqlColumns
...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 with sqlColumns(db,"X.test") //it returns Error in sqlColumns(db, "X.test") : 'X.test': table not found on channel If I do sqlColumns(db, "test") it returns [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE [6] TYPE_NAME P...
2008 Sep 17
1
creating horizontal dataframes with column names
Greetings -- in order to write back to SQL databases, one needs to create a dataframe with values. I can get column names of an existing table with sqlColumns. Say I have a vector of values (if they're all the same type), or a list (if different). How do I create a dataframe with column names given by my sqlColumns? To make it concrete, how do we make a dataframe A B C 1 2 3 out of column.names <- LETTERS[1:3] values <- 1:3 ? Cheer...
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 EIDS TEST_ARTCL_INST CHANNEL_ID 2 EIDS TEST_ARTCL_INST ARTICLE_TEST_ID 3 EIDS TEST_ARTCL_INST CHANNEL_OLD_ID 4...
2003 Feb 11
1
RPgSQL W2K
Hi, i found tis message in the archive and have got the same problems ? John, perhaps you have found now a way install RPgSQL for windows2000, or anybody other ? many thanks for advance christian [SNIP] I wonder whether anyone has succeeded in building either the RPgSQL or the Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to share either the binary package(s) or
2010 Nov 25
1
RODBC
...9999 Arizona Arizona 9999 > sqlUpdate(accesChannel , foo, "USArrests") Error in sqlUpdate(accesChannel, foo, "USArrests") : cannot update 'USArrests' without unique column > I am using R 2.12.0(2010-10-15) Using Microsoft access 2003. Furthermore, the sqlColumns(accesChannel , "USArrests") returns the following information > sqlColumns(accesChannel , "USArrests") TABLE_CAT TABLE_SCHEM TABLE_NAME 1 C:\\ARTIFICALDESKTOP\\CurrentDownloads\\termstrc\\data <NA> USArrests 2...
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
2001 Mar 12
2
RODBC problems
...uot;test") sqlSave(channel,dat=totale) Error in sqlTables(channel)[, 3] : incorrect number of dimensions Actually it gave me other error messages, in previous trials *with the same commands*. Once it said something like ... vector maximum memory size reached... Another time something like ...sqlColumns(...??) c(30,2,30...) should be a vector names ^^^^^^^^^^^^^ (these are the values in the first variable) To reduce the load I created a 1x524 dataframe (to create th...
2008 Jul 23
2
Using RODBC to use SQL queries
...with my syntax? I have tried a few things, like attaching the tables to the data frame but with no luck. According to the PDF, I should be able to use this argument: >odbcQuery(channel, query, rows_at_time,=attr(channel, "rows_at_time")) I have also tried to use arguments like: >sqlColumns(channel, "SAMPLE_YEA") but with no luck. Any help with this would be much appreciated! Thanks in advance, Megan
2019 Apr 16
3
PROBLEMAS NOMBRES DE COLUMNAS CON ESPACIOS CONEXION R-SQL
...quot;Date" "Time" "Seasson" "TimeH" "Day" "Holiday" [7] "Corte optimo" "Corte diario" Y si obtengo los nombres de la tabla SQL: sqlColumns(conexion1, "AUXILIAR") TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME OS MKOnline dbo AUXILIAR Date OS MKOnline dbo AUXILIAR Time OS MKOnline dbo AUXILIAR Seasson OS MKOnline dbo AUXILIAR TimeH OS MKOnline dbo AUXILIAR Day OS MKOnline dbo AUXILIAR Holiday OS MKOnline dbo AUXILIAR Corte opti...
2007 Mar 07
0
sqlSave help!
...7 It exists and I can get data from it, but if I try to use fetch or columns: > sqlFetch(channel, "TestDB.[SILICON\\holouis1].clep_tier_shift") Error in odbcTableExists(channel, sqtable) : 'TestDB.[SILICON\holouis1].clep_tier_shift': table not found on channel > sqlColumns(channel, "TestDB.[SILICON\\holouis1].clep_tier_shift") Error in sqlColumns(channel, "TestDB.[SILICON\\holouis1].clep_tier_shift") : 'TestDB.[SILICON\holouis1].clep_tier_shift': table not found on channel Now if I try to save, it says error: table exists already...
2011 Dec 20
1
RODBC Error: 'getCharCE' must be called on a CHARSXP
...UE,) close(channel) However, I get the following error immediately after sqlQuery command: Error in odbcQuery(channel, query, rows_at_time) : 'getCharCE' must be called on a CHARSXP I believe my connection is good because I used the following commands to successfully view the columns: sqlColumns(channel, TableXYZ) There doesn't seem to be much info on "getCharCE" and/or "CHARSXP. Any guidance the group could provide this vey new user to R, would be greatly appreciated [[alternative HTML version deleted]]
2009 Mar 01
1
Temporary tables with Microsoft SQL?
...r=SQL Server;server=foo;Initial Catalog=bar;Integrated Security=SSPI;") > x<-data.frame(1:10) > colnames(x) <-c("x") > sqlSave(channel, x, "#x", verbose=TRUE) Query: CREATE TABLE "#x" ("rownames" varchar(255), "x" int) Error in sqlColumns(channel, tablename) : ?#x?: table not found on channel > sqlSave(channel, "#x", verbose=TRUE) #repeat Query: CREATE TABLE "#x" ("rownames" varchar(255), "x" int) Error in sqlSave(db_i3_eic, x, "#x", verbose = TRUE) : [RODBC] ERROR: Could no...
2009 Sep 23
4
Error When Using Postgresql Schema With Realtime Sip
I am using asterisk 1.6.1.6 and have been setting up a system to use a Postgresql database as the realtime DB via the ODBC route. I have got extensions and voicemail working but am having trouble with SIP The problem seems to be with using a schema. If I put the table "sip" in the schema "foo" then I add this entry to extconfig.conf sippeers => odbc,psqldb,foo.sip Restart
2010 Aug 13
0
some helpful tips on using RODBC
.... Instead of guessing which data types are being used, I simply query the database and grab the data types (this will work even if the database has columns but is empty), then use this information when populating. In short, I do the following: library(RODBC) dbCon <- odbcConnect(db) tmp <- sqlColumns(dbCon, dbTable) ## this function grabs a bunch of info about the columns) varTypes <- as.character(tmp$TYPE_NAME) names(varTypes) <- as.character(tmp$COLUMN_NAME) sqlSave(dbCon, dataSet, dbTable, append=TRUE, rownames=FALSE, varTypes=varTypes) The "secret ingredient" here is varTyp...
2002 Jul 18
2
RODBC and Excel Files
...r(255) ,l varchar(255) ,m varchar(255) ,n varchar(255) ,o varchar(255) ,p varchar(255) ,q varchar(255) ,r varchar(255) ,s varchar(255) ,t varchar(255) ,u varchar(255) ,v varchar(255) ,w varchar(255) ,x varchar(255) ,y varchar(255) ,z varchar(255) , varchar(255) )" Error in sqlColumns(channel, tablename) : fau01 :table not found on channel 0 How can i save my dataframe ??? Thanks in advance. -- St?phane DRAY --------------------------------------------------------------- Biom?trie et Biologie ?volutive - Equipe "?cologie Statistique" Universite Lyon 1 - Bat 711 -...
2007 Aug 14
4
Import of Access data via RODBC changes column name ("NO" to "Expr1014") and the content of the column
...language R version.string R version 2.5.1 (2007-06-27) ## code get.table <- function(name, db, drop = NULL){ .con <- try(odbcConnectAccess(db), silent = T) if(!inherits(.con, "RODBC")) return(.con) ## exclude memo columns .t <- try(sqlColumns(.con, name)) if(inherits(.t, "try-error")){close(.con); return(.t)} .t <- .t[.t$"COLUMN_SIZE" < 255, "COLUMN_NAME"] .t <- paste(.t, collapse = ",") ## get table .t <- paste("select", .t, "from", name) .d <- try(s...
2004 Nov 25
0
Problem with ODBC access to SQL database
...fine when I use MS Access as ODBC server. ----------- offending code and output ------------------- > library(RODBC); > channel <- odbcConnect("opus"); > data(USArrests) # R < 2.0.0 only > sqlSave(channel, USArrests, rownames = "state", addPK=TRUE) Error in sqlColumns(channel, tablename) : USArrests : table not found on channel Check case parameter in odbcConnect > sqlSave(channel, USArrests, rownames = "state", addPK=TRUE) Error in sqlSave(channel, USArrests, rownames = "state", addPK = TRUE) : [RODBC] ERROR: Could not SQLExecD...
2012 Dec 21
0
segfault reading large BLOB from SQL Server
..." "10.50.4000" "03.50" "h41_devl" "libtdsodbc.so" Driver_Ver ODBC_Ver Server_Name "0.91" "03.52" "MSSDEV1" > sqlColumns(conn, "v_MAFiles") TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS 1 H41 dbo v_MAFiles ReleaseId 1 char 3 3 NA 2 H41 dbo v_MAFiles AsOfDate...
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