search for: sqlexecdirect

...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. I get the following error message: > sqlSave(channel, Adat) Error in sqlSave(channel, Adat) : [RODBC] ERROR: Could not SQLExecDirect The data was fetched from the same Access database before and was not manipulated before the attempt to save. What's wrong? Any advice is welcome! Peter -- "Feel free" ? 10 GB Mailbox, 100 FreeSMS/Monat ...

...<NA> 1319 <NA> ORESTE S_TYP_COLLEGES TABLE <NA> 1320 <NA> ORESTE S_TYP_ENSEIGNEMENT TABLE <NA> ... > sqlQuery(essai, "select * from S_TYP_COLLEGES") [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: Table ou vue inexistante\n" I have also tried the essai2 <- odbcDriverConnect(connection="essai2") But with no succes. On Lun Juil 16 15:32 , Prof Brian Ripley <ripley at stats.ox.ac.uk&gt...

...-2.5.0\Forbes2000.xls DefaultDir=C:\Program Files\R\R-2.5.0 Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 Z>sqlQuery(cnct, "select * from \"Forbes2000\\$\"") However, I got error like this: [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "42S02 -1305 [Microsoft][ODBC Excel Driver] Microsoft Jet Êý¾Ý¿âÒýÇæ ÕÒ²»µ½¶ÔÏó'Forbes2000\\$'¡£ÇëÈ·¶¨¶ÔÏóÊÇ·ñ´æÔÚ£¬²¢ÕýÈ·µØд³öËüµÄÃû³ÆºÍ· ¾¶¡£" I do can find Forbes2000.xls in directory, C:\Program Files\R\R-2.5.0. Would anybody help me out? Thanks for any sugges...

...ng example: > library(RODBC) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") > sqlClear(xlsx,"newsheet2",errors=TRUE) [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "HY000?Þêÿÿ\003 -5410 [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM." > sqlClear(xlsx,"newsheet2",errors=TRUE) [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "HY000?Þêÿÿ\003 -5410 [Microsoft][ODBC Exc...

...;'MED Supporting Evidence$'Print_Area" > faults <- sqlFetch(channel, sqtable = 'Data', + colnames = FALSE, as.is = TRUE) > faults [1] "HY001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined." [2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM [Data$]'" > faults <- sqlFetch(channel, sqtable = 'Data$', + colnames = FALSE, as.is = TRUE) > faults [1] "HY001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined." [2] "[RODBC] ERROR: Could not SQLExecDirec...

...hannel, 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 not SQLExecDirect 42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named '#x' in the database. > sqlSave(channel, "x", verbose=TRUE) # try without hash Query: CREATE TABLE "x" ("rownames" varchar(255), "x" int) Error in sqlSave(...

...---------------cut here---------------start-------------->--- con <- odbcConnect("PostgreSQL-DB", uid="user", pwd="password", case="postgresql") R> sqlSave(con, table.df) Error in sqlSave(con, table.df) : [RODBC] ERROR: Could not SQLExecDirect 42601 7 [unixODBC]Error while executing the query; ERROR: syntax error at or near "end" at character 140 ---<---------------cut here---------------end---------------->--- If I rename the column to something else (e.g. "ending"), this proceeds without problems. What cou...

...oldstyle = FALSE,safer=FALSE) Query: CREATE TABLE Chimaera20_3years$ (Date varchar(255), 000Tax varchar(255), 1500Tax varchar(255), 3000Tax varchar(255), 4650Tax varchar(255)) Error in sqlSave(con, x, tablename = "Chimaera20_3years$", append = FALSE, : [RODBC] ERROR: Could not SQLExecDirect 37000 -3551 [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement. > sqlSave(con, x, tablename = "[Chimaera20_3years$]", append = FALSE, + rownames = FALSE, colnames = TRUE, + verbose = TRUE, oldstyle = FALSE,safer=FALSE) Query: CREATE TABLE [Chimaera20...

...t read.c:76 #4 0x0044619f in tds_process_tokens (tds=0xb7938c90, result_type=0x2abb360, done_flags=0x2abb364, flag=26900) at token.c:509 #5 0x00432e7d in odbc_process_tokens (stmt=0xa3f3658, flag=26900) at odbc.c:3268 #6 0x0043736c in _SQLExecute (stmt=0xa3f3658) at odbc.c:3118 #7 0x00439561 in SQLExecDirect (hstmt=0xa3f3658, szSqlStr=0x2abb640 "INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ({ts '2010-04-28 10:01:26'},?,?,?,?,?,?"..., cbSqlStr=-3) at odbc.c:3227 #8 0...

...l! Can someone confirm whether there is a bug or not? I was trying to use sqlUpdate in place of sqlSave as data set I import has duplications. However I get errors while using fast=FALSE argument to safely update/ignore duplicates: Error while executing the query[RODBC] ERROR: Could not SQLExecDirect 'UPDATE "data" SET "logger"=1, "value"=0.0321584 WHERE "time"=2008-09-22 13:15:00' Error in sqlUpdate(con2, na.omit(dat), "data", fast = FALSE) : 42601 7 ERROR: syntax error at or near "13"; It looks like POSIXct class is...

Hello, I use a RODBC connection to a MySQL server on a Debian machine. The call to odbcConnect() seems to be ok, but the result of the first sqlFetch(channel,"t_studie") retrieves this data frame: [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "42000 1064 [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-Debian_1bpo1-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"t_studi(\004" Please note the funny character at the end of the...

Hello, I would like to call a function that can take infinite time to be executed in some circumstances (which can not be easily detected). So, I would like that once the function is being executed for more than two seconds it is stopped. I have found documentation for timers but i did not found how to "kill" a function. Moreover, I would like not to change the function code (it should

...<- paste("SELECT * FROM", tbls$TABLE_NAME[1], sep = ' ') > qry [1] "SELECT * FROM Sheet1$" > sqlQuery(con, qry) and got the error message [1] "42000 -3506 [Microsoft][ODBC Excel Driver] Syntax error in FROM clause." "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM Sheet1$'" Any advise as to why and how to fix it? What's the syntax error that I'm just not seeing? Thanks, Walt -- ________________________ Walter R. Paczkowski, Ph.D. Data Analytics Corp. 44 Hamilton Lane Plainsboro, NJ 08536 ________________________...

...pdate spreadsheets directly through R scripts. Simple queries seem to work fantastic! But, I am missing something when it comes to writing. sqlQuery( myChan,"insert into [my customers$] ( CUST_ID, NAME, SOCIAL ) VALUES( 5,'robin',5678 ) " ) [1] "[RODBC] ERROR: Could not SQLExecDirect" "S1000 -3035 [Microsoft][ODBC Excel Driver] Operation must use an updateable query." myChan = odbcConnectExcel("c:\\foo.xls") myChan RODB Connection 13 Details: case=nochange DBQ=c:\foo.xls DefaultDir=c:\ Driver={Microsoft Excel Driver (*.xls)} DriverId=7...

Hello, i have problem with the following code (I'm using sqlQuery function from RODBC package): eval(parse(text="g_1 <- sqlQuery(cnn_1, \"select aa from bb.[cc\\dd].ee\")")). I get the error message: "[RODBC] ERROR: Could not SQLExecDirect" "S0002 208 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'bb.cc\dd.ee'." It seems that R is replacing square brackets that are needed for database to execute query. How can I force R to change its behavior and leave square brackets unchanged? Any...

Hello, i have problem with the following code (I'm using sqlQuery function from RODBC package): eval(parse(text="g_1 <- sqlQuery(cnn_1, \"select aa from bb.[cc\\dd].ee\")")). I get the error message: "[RODBC] ERROR: Could not SQLExecDirect" "S0002 208 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'bb.cc\dd.ee'." It seems that R is replacing square brackets that are needed for database to execute query. How can I force R to change its behavior and leave square brackets unchanged? Any...

...ccess. I just installed RODBC and it seems to be working well except when I use the date to condition the query. For example the query below sqlQuery(channel, "select date from tblUScpi where (date > d2) order by date") returns the following error [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "07001 -3010 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1." I checked that d2 and the elements in date belong to the same class ("POSIXt" "POSIXct"). Can anybody help me? -- View thi...

...M TABLE_NAME TABLE_TYPE REMARKS 1 T:\\data\\in\\nameclass <NA> nameclass$ SYSTEM TABLE <NA> > qry = paste("SELECT * FROM '",tbls$TABLE_NAME[1],"'",sep="") > result = sqlQuery(con,qry) > result [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "42000 -3506 [Microsoft][ODBC Excel Driver] Syntax error in FROM clause." [[alternative HTML version deleted]]

...<NA> '31032009$'      TABLE    <NA> > query = paste("SELECT * FROM", tables$TABLE_NAME[1]) > sqlQuery(connection,query) [1] "HY000 -3003 [Microsoft][ODBC Excel Driver] Syntax error in query.  Incomplete query clause." [2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM '30092007$''"        Thanks, Regards, Han Chin __________________________________________________ [[alternative HTML version deleted]]

...wrong? library(RODBC) channel<-odbcConnect("xxx",uid="xxx",pwd="xxx") sqlQuery(channel, "select * from SCHEMA.TABLE") [it works fine] sqlQuery(channel, "select * from SCHEMA.TABLE where COL1>10") [returns [""[RODBC] ERROR: Could not SQLExecDirect" [" (...) :invalid table name"] -- View this message in context: http://www.nabble.com/problems-with-RODBC%2C-sqlQuery-tp25066803p25066803.html Sent from the R help mailing list archive at Nabble.com.