How to use OLDB to connect Postgresql

[#1]

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?

[maksim_senin]

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

[jagan]

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.