search for: sqlprepare

...#39;a055-re-0020_ph_pv_flt' and datetime >= 'nov 1, 2001 2:00pm'") > test test [1] "37000 201 [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_prepare' expects parameter '@stmt', which was not supplied." [2] "[RODBC]ERROR: Could not SQLPrepare" Any thoughts? Shawn Way Tanox, Inc. -------------- next part -------------- An HTML attachment was scrubbed... URL: https://stat.ethz.ch/pipermail/r-help/attachments/20011113/74d57dd0/attachment.html

...TABLE <NA> ... If I try to fetch a table I get as result > data<-sqlFetch(channel,"'Scan 2$'",rownames=T) > data [1] "S1000 -3003 [Microsoft][ODBC Excel Driver] Syntax error in query. Incomplete query clause." [2] "[RODBC] ERROR: Could not SQLPrepare" If I now change by hand the Excel table, e.g. to "Scan 1" -> "Scan1" I get TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 2 <NA> Scan1$ SYSTEM TABLE <NA> 4 <NA> 'Scan 10$' TABLE <NA> 5 <NA&...

...se\\R\\Doubs NA Milieu$ SYSTEM TABLE NA I have two problems. (1) For loading the tables in R, I use > sqlFetch(connection,"Faune$") [1] "37000 -3506 [Microsoft][Pilote ODBC Excel] Erreur de syntaxe dans la clause FROM." [2] "[RODBC]ERROR: Could not SQLPrepare" There is a syntax error (probably to name the table) but i don't find the answer.. (if you know it..) To solve this problem, I use an alternative: > sqlQuery(connection,"select * from [Faune$]")[1:5,] a b c d e f g h i j k l m n o p q r s t u v w x y z + 1 0 3 0 0 0 0 0...

...55-re-0020_ph_pv_flt' and DateTime >= 'nov 1, 2001 > 2:00pm'") > test test [1] "37000 201 [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_prepare' expects parameter '@stmt', which was not supplied." [2] "[RODBC]ERROR: Could not SQLPrepare" Any thoughts? Shawn Way Tanox, Inc. -------------- next part -------------- An HTML attachment was scrubbed... URL: https://stat.ethz.ch/pipermail/r-help/attachments/20011114/644d71e0/attachment.html

...t;oracle") > sqlQuery(a,"(select VALFACT>500 from EPISGDHS) UNION (select VALFACT<1000 from EPISGDHS)") Comes the error: [1] "S1000 923 [unixODBC][Easysoft][Oracle]ORA-00923: FROM keyword not found where expected at offset 15" [2] "[RODBC] ERROR: Could not SQLPrepare" Margarida Igreja. using WinNT [[alternative HTML version deleted]]

...uot;oracle") > sqlQuery(a,"select DISTINCT(DOENT_ID) from EPISGDHS where (VALFACT BETWEEN 100 AND 50)") Comes the error: [1] "S1000 904 [unixODBC][Easysoft][Oracle]ORA-00904: \"DOENT_ID\": invalid identifier at offset 16" [2] "[RODBC] ERROR: Could not SQLPrepare" Margarida Igreja. using WinNT [[alternative HTML version deleted]]

...n with a few sqlSave() calls, I get an error, for example: Error in sqlSave(channel = channel, dat = USArrests[, 1, drop = FALSE], : HY000 1461 [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.20]Can't create more than max_prepared_stmt_count statements (current value: 16384) [RODBC] ERROR: Could not SQLPrepare 'INSERT INTO `usarrests` ( `murder` ) VALUES ( ? )' In my setup the MySQL global variable max_prepared_stmt_count has the default setting of 16K. If I reset the variable higher, I can run a while longer, but this is not a permanent solution. Digging around for a solution, I see that the...

Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking around before experimenting further... Thanks, Laurent