search for: sqlexecut

...; # https://www.r-bloggers.com/parameterized-sql-queries/ > > # https://cran.r-project.org/web/packages/RODBCext/ > vignettes/Parameterized_SQL_queries.html > > > > library(RODBCext) > > filterData <- data.frame('cosa'= c('libros')) > > data <- sqlExecute(cn, "SELECT * FROM prueba WHERE cosa = ?", filterData, > fetch = TRUE) > > if(length(data$id) == 0) > > { > > print ("no hay elementos") > > } else > > { > > print ('hay elementos') > > } > > > > # generar lo...

Buen dia compañerxs de R, les traigo una pregunta bastante especifica. En el trabajo me estan requiriendo el uso de SQL, asi q estoy aprendiendo a usarlo desde R, con el paquete RODBC. Mi problema puntual es que al crear una tabla en el servidor SQL a partir de un data frame en R (usando la funcion sqlSave) no puedo definir el tipo de variables que quiero usar en el data frame. Segun entiendo

...; # https://www.r-bloggers.com/parameterized-sql-queries/ > > # https://cran.r-project.org/web/packages/RODBCext/ > vignettes/Parameterized_SQL_queries.html > > > > library(RODBCext) > > filterData <- data.frame('cosa'= c('libros')) > > data <- sqlExecute(cn, "SELECT * FROM prueba WHERE cosa = ?", filterData, > fetch = TRUE) > > if(length(data$id) == 0) > > { > > print ("no hay elementos") > > } else > > { > > print ('hay elementos') > > } > > > > # generar lo...

...quot;CUSID" "WELLE" "Q21" "BEWERB" ... sqlSave(channel,mno.x,verbose=T) Query: CREATE TABLE mno.x (rownames varchar(255) ,BEWERB double ,MEDIENPR?SENZ double ,GESCHLECHT double ) Error in sqlSave(channel, mno.x, verbose = T) : [RODBC] ERROR: Could not SQLExecute >>str(mno.x) `data.frame': 583 obs. of 3 variables: $ BEWERB : num 2 2 1 2 1 1 2 2 1 1 ... $ MEDIENPR?SENZ: num 73.3 75.0 70.0 60.0 100.0 ... $ GESCHLECHT : num 1 1 1 1 1 1 1 1 1 1 ... { RODBC-1-0-1,R-1.6.2,W2k } many thanks, christian

...; x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 37 <NA> TKF ABTGRNAMEN TABLE <NA> > # ok, so the table I am looking for ("ABTGRNAMEN") is there, but: > sqlFetch(channel, "ABTGRNAMEN") [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S0002 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not exist\n" > # I also tried: > sqlFetch(channel, "TKF.ABTGRNAMEN") Error in odbcTableExists(channel, sqtable) : TKF.ABTGRNAMEN : table not found on channel...

...ng that c:\test.xls is a standard "blank" Excel spreadsheet; i.e. Sheet1, Sheet2, Sheet3) > con = odbcConnectExcel("c:\\test.xls") > df = data.frame(x = rnorm(10), y = rnorm(10), z = letters[1:10]) > sqlSave(con, df) Error in sqlSave(con, df) : [RODBC] ERROR: Could not SQLExecute Where am I going wrong? Thanks, Dave

...ibodbcpsql.so (gdb) bt #0 0x00140adf in CI_read_fields () from /usr/lib/libodbcpsql.so #1 0x001594dc in QR_fetch_tuples () from /usr/lib/libodbcpsql.so #2 0x0014255e in CC_send_query () from /usr/lib/libodbcpsql.so #3 0x0015c87c in SC_execute () from /usr/lib/libodbcpsql.so #4 0x0014bd60 in PG_SQLExecute () from /usr/lib/libodbcpsql.so #5 0x0014bf4d in SQLExecute () from /usr/lib/libodbcpsql.so #6 0x00356cf7 in SQLExecute () from /usr/lib/libodbc.so.1 #7 0x00128e76 in ast_odbc_prepare_and_execute (obj=0x86e76e0, prepare_cb=0x113120 <custom_prepare>, data=0xb7d83794) at res_odbc.c:96 #8 0...

...or") -> channel > data(USArrests) > sqlSave(channel, USArrests, verbose = TRUE) Query: CREATE TABLE USArrests (rownames varchar(255) ,Murder float8 ,Assault int4 ,UrbanPop int4 ,Rape float8 ) Error in sqlSave(channel, USArrests, verbose = TRUE) : [RODBC] ERROR: Could not SQLExecute When issuing this comamnd, a table is created in the specified database, with fields corresponding to names(USArrests), except in lower case, but the fiels contain no data. Does anyone know the reason for this? One of my guesses is that the table and field names are converted into lower cases...

...gt; con RODB Connection 0 Details: case=nochange 0?????????? > sqlTables(con) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE [5] REMARKS <0 rows> (or 0-length row.names) > sqlQuery(con,"select * from Medium") [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S1000 1 [unixODBC] Msg 208, Level 16, State 1, Server BIGSKY, Line 1\nInvalid object name 'Medium'.\n" > sqlQuery(con,"select * from cmp.Medium") [1] MediumKey Medium IsSpecies <0 row...

...Add NAMESPACE. * odbcConnect{Access,Dbase,Excel} allow a missing file name (and will bring up a dialog box to search for it). * odbcGetInfo returns more information in a 8-element character vector (based on an idea of Matthew Dowle). * The C code calls SQLExecuteDirect rather than SQLExecute and does not call SQLCloseCursor, based on a problem report from Matthew Dowle using MS SQLServer. Repeated calls to sqlGetResults now work. * New function sqlFetchMore. * Table names in Access with embedded spaces are m...

...and 256 columns; its structure is roughly as follows: > # [blank] 0 1 2 ... 254 > # 0 70 70 71 ... 63 > # [89 rows deleted] > # 90 57 56 52 ... 37 > frame1 <- sqlQuery(channel, "select * from [Sheet1$]") > frame1 [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S1001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined." > odbcGetInfo(channel) [1] "EXCEL version 08.00.0000. Driver ODBC version 03.51" > version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status majo...

...Add NAMESPACE. * odbcConnect{Access,Dbase,Excel} allow a missing file name (and will bring up a dialog box to search for it). * odbcGetInfo returns more information in a 8-element character vector (based on an idea of Matthew Dowle). * The C code calls SQLExecuteDirect rather than SQLExecute and does not call SQLCloseCursor, based on a problem report from Matthew Dowle using MS SQLServer. Repeated calls to sqlGetResults now work. * New function sqlFetchMore. * Table names in Access with embedded spaces are m...

asterisk*CLI> load cdr_unixodbc.so Loaded /usr/lib/asterisk/modules/cdr_unixodbc.so => (unixODBC CDR Backend) == Parsing '/etc/asterisk/cdr_unixodbc.conf': == Parsing '/etc/asterisk/cdr_unixodbc.conf': Found -- cdr_unixodbc: dsn is MySQL-asterisk -- cdr_unixodbc: username is root -- cdr_unixodbc: password is [secret] -- Connected to MySQL-asterisk it

Does any one know how to setup SQLserver with ruby1.9. It was working on an earlier version and now nothing works! I have installed the gems dbi ,dbd-odbc and activerecord-odbc-adapter and can connect in straight Ruby. However, using rails with database.yml nothing works! I hosed everything and reinstalled rails and now, I get Win32/Parite virus on ruby.exe. Any ideas? I''m losing