topic How to use OLDB to connect Postgresql in QlikView

How to use OLDB to connect Postgresql

Wed, 31 Oct 2012 08:01:57 GMT

Reload script showed "connected", but select columns failed, error info:ErrorSource: PgOleDb, ErrorMsg: Fatal error in query.

I tried that use ODBC to connect Postgresql, it's ok.

How to use OLDB to connect Postgresql?

Re: How to use OLDB to connect Postgresql

maksim_senin — Tue, 27 Jan 2015 02:24:38 GMT

Hi,

ODBC dirver really works well (e.g. from here - PostgreSQL: File Browser).

As for OLE DB, personally I did not find free OLE DB which works well, one commercial I found at PostgreSQL Native OLEDB Provider (PGNP) works well in trial with significatn limit (no more than 100 rows per quesrfy)... so I chose ODBC instead of ~400 usd

Best regards,

Maxim

Re: How to use OLDB to connect Postgresql

jagan — Tue, 27 Jan 2015 02:37:11 GMT

Hi,

Try giving SQL keyword before query like below

SQL SELECT

FROM TableName;

or Try generating the query using Select button in Edit Script window.

Regards,

Jagan.