Skip to Content
0
Former Member
Apr 06, 2015 at 02:58 PM

Error accessing external PostgreSQL database

28 Views

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!