search for: 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...

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...

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...

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

...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...

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

...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...

...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

...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...

...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...

...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]]

...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...

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

.... 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...

...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 -...

...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...

...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...

..." "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...

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