Error with XA transactions

Hi All, Hope someone familiar with XA transaction setup via WebSphere can provide me some answers. We recently switched from Connection Pooling to XA transactions via WebSphere, connecting to some Informix 9.40 databases. We started receiving SQL Exception error messages "The database server is not licensed for distributed data access". Investigation showed a table in the database that was actually a synonym table linking to a different instance on a separate server. When trying to Insert into that table, the error popped up. (Using dbaccess to insert the row works just fine, so we know the servers are talking). Switching the connection back to Pooling allows the transaction to complete correctly. The XA transactions work fine while using the main server, but when accessing the synonym table, they fail. Any ideas what settings need to be in order for "distributed" transactions to work? Thanks! Michael Hoffman

We have seen the same problem on 11.50. As I understand it the error message is incorrect, I think the problem is that the server can't handle XA transactions on synonyms. This is understandable, but not documentet and the error message does not help you. We are Weblogic not WebSphere, I don't think that the problem is in the TM but in the databaserver. Regards Ulf