Jitterbit · Database connector (ODBC Excel driver)
Operation must use an updateable query
Short answer
This Jitterbit error means the ODBC Excel driver opened the file read-only, because the connection string does not set read/write mode. In the Database connection's Connection String field, append ReadOnly=0; to the end of the string.
VerifiedLast verified
01Error text
[Microsoft][ODBC Excel Driver] Operation must use an updateable query02Likely causes
- The ODBC Excel driver opens the file read-only unless the connection string explicitly sets read/write mode.
03How to fix it
- In the Database connection's Connection String field, append
ReadOnly=0;to the end of the string.
04Official documentation
→Related errors
- Base64 decoding failedThis Jitterbit error in DBLookup or DBExecute means an agent earlier than 12.9 tried to Base64-decode a JDBC result that only looks like Base64, such as a JWT. For private agents, upgrade to version 12.9 or later.
- Database connection could not be established due to a security policy violationThis Jitterbit error means agent 12.10 or later blocked a database connection to a loopback address or one that uses a restricted connection string parameter. On the private agent, configure the [JdbcSecurity] section of jitterbit.conf to allow the specific connection or parameter.
- Field value too long / values were truncatedThis Jitterbit database error means a mapped source value is longer than the target column, and by default the value is rejected. In the activity configuration, enable Allow truncation of character fields.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries