Informix Error -9253: Xadatasource datasource_name not found.

Reasons / Common Causes

-9253 fires when a DROP XADATASOURCE statement names a datasource that doesn't exist — per the official guidance.

1. A misspelled or nonexistent xadatasource name in a DROP XADATASOURCE statement, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Use the correct name, per the official guidance.

Examples

Dropping a nonexistent xadatasource

DROP XADATASOURCE ds_typo;   -- -9253 if no such xadatasource exists

Diagnostic Checks

1. Check the system catalog for the actual xadatasource name, and correct the DROP statement.

Related Errors / Related Topics

• -9251 — "Xadatasource datasource_name already exists in database." The inverse case — creating a name that already exists.
• -9252 — "Xadatasource type datasource_type_name not found." The same class of not-found error, for xadatasource types rather than instances.

The named xadatasource doesn't exist — check the system catalog and correct the name.