Displaying 8 results from an estimated 8 matches for "sqlprepar".
Did you mean:
sqlprepare
2001 Nov 13
1
RODBC
...#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
2003 Sep 23
1
RODBC access to MS-Excel (PR#4266)
...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...
2002 Jul 18
2
RODBC and Excel Files
...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...
2001 Nov 14
0
RODBC: Minor problem, I hope.
...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
2004 Mar 29
0
UNION
...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]]
2004 Mar 29
0
BETWEEN
...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]]
2012 Dec 13
0
max_prepared_stmt_count exceeded using RODBC + 64-bit win7
...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...
2006 Feb 27
4
prepared query with RODBC ?
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