Failed to allocate statement

[Tomi Saloniemi]

I'm having problem with inserting or updating data from FM 7 to MySQL via ODBC. Sometimes i get error message "failed to allocate statement". It's a bit frustrating if i'm inserting hundreds of rows and then figuring out which one was left out... Any ideas what is causing this?

[pigslow]

I had the opposite problem...from MySQL to filemaker.

I found a check box on the Advanced tab for the ODBC driver setup.

"Allow big results"

I found by checking this, you can import more records.

I don't know if that helps but there it is.

[Tomi Saloniemi]

Could the problem be that FM hasn't yet calculated all data needed for MySQL insert statement and thus giving error message could not allocate statement?

And if so, how can i make sure that the statement is made after it is ready?

Anyone have any ideas about this?

[Tomi Saloniemi]

anyone know what does the error code 1407 Failed to allocate statement (ODBC) mean? What causes it? Help please!