P.S.: I completely removed the datetime strings from the data set and am still getting the same error, so it's definitely something else.
fastinsert returns "Numeric value out of range" error, but insert works
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi! I have a situation where, on precisely the same data set, fastinsert is returning
"Java exception occurred: sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC SQL Server Driver]Numeric value out of range"
but insert works. Looking at the help for fastinsert I see:
"...fastinsert ... supports more (emphasis added) object types than insert"
and the only exception to that I see documented is
"The fastinsert function only supports dates in U.S. format; that is, dates in mm/dd/yyyy format."
I did have this problem, but I corrected it (at least, the error I was getting before is different than the one cited above).
Is anyone aware of any other (undocumented) fastinsert limitations? Any other ideas?
Thanks!
2 comentarios
Respuestas (0)
Ver también
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!