topic Re: PostGreSQL connection in QlikView

PostGreSQL connection

Mon, 13 Sep 2010 19:23:48 GMT

Hello,

I am trying to connect to a postgreSQL 8.4 database over vpn. I am able to connect to the db using the postgres admin console. I registred the postgresql odbc driver so that it now shows up on the connect menu in the qlikview scripting window. However when I click connect I don't get a connection string. Also if I click 'select' It does not show any tables.

Anybody try connecting to postgresql before? Any suggestions on how to get past this issue.

Any help would be appreciated.

PostGreSQL connection

Mon, 13 Sep 2010 22:30:12 GMT

It turns out it was 2 issues. first you need to register the postgrs odbc driver. Second you need to make sure that the driver installed correctly. I had issues of my driver installation being corrupted, and found out that it was a fairly common issue with the postgresql odbc drivers.

PostGreSQL connection

Sun, 06 Mar 2011 05:02:59 GMT

hi..

can you guide me on how to connect to postgresql from the beginning? im not familiar on linux and dont how to setup the dsn.

thank you..i wish you are willing to help

Re: PostGreSQL connection

maksim_senin — Tue, 27 Jan 2015 02:21:21 GMT

Hi,

First of all you should get a driver:

ODBC - PostgreSQL: File Browser

OLE DB - PostgreSQL Native OLEDB Provider (PGNP) (personally I did not found free OLE DB which works well)

Install the driver and try to connect to your DB server, that depends on the server parameters.

Best regards,

Maxim