Hi!
I'm trying to write data on an external PostgreSQL database using the 'Generic DBMS_Output' Output Adapter. First of all, I have installed the PostgreSQL ODBC driver (version 09_03_0400), and it seems to work OK (when I test the connection from the operating system I receive the "connection successful" message).
From the ESP Studio (version 5.1) I can also see the database tables from the Data Service View, so it seems the ESP is actually reaching the remote database and retrieving data from it.
Anyway, when I try to access the tables (any of them) by clicking twice on them, or when I try to discover the schema, I receive the following error:
[FAILURE:Unable to perform discovery on adapter db in][Code: 702006][EXCEPTION:xmlrpc call Connection.getFieldNames() failed with msg: ]
That is, it seems that ESP is not able to get the table field names for some reason...
I would appreciate if someone can help me with this.
Thanks a lot in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.