Displaying 1 result from an estimated 1 matches for "max_prepared_stmt_count".
2012 Dec 13
0
max_prepared_stmt_count exceeded using RODBC + 64-bit win7
...it versions AFAIK.
sqlQuery and sqlSave work fin as expected, but in a long session 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...