topic Re: Connecting qlikview to PostgreSQL with ODBC connector in QlikView

Connecting qlikview to PostgreSQL with ODBC connector

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

Hi all,

I'm new to the forum here. Registered specially for the purpose of posting this very question, so I hope there is a Guru around here who can help me out with it hehe

So, this is the situation:
- The machine is a 64 bit Windows 7.

- Qlikview 64 bit version installed.

- PostgreSQL for desktop 9.6 32 bit version installed.

- Last version ODBC drivers for Postgre installed, 32 bit as well.

- Connector made using the administrative tools in the control panel section.

There is a database, 'mydb', with a table, 'people', with some information (3 rows). I have tried everything to get QlikView to connect to the database but I have not quite got it right yet.

The steps I follow:

1. Open QlikView and create a new application.

2. Ctr + E to open editor, then mark the "force 32 bits version" check box, select "ODBC" and hit "Connect".

3. Select my recently created connector, namely "PostgreSQL30", which in turn opens a dialog box like in the attached picture.

I think that my mistake might be in this step, because I leave the 'Server' space blank, but I don't really know what should I write there 😕

4. Connect.

Then, the easy "ODBC CONNECT32 TO PostgreSQL30;" is written in the editor, but when I try to insert a select query afterwards, eventhough the workings of the connector seem to work just right, the select dialog doesn't show any table to be selected **HULK MAD**

Really, any help will be appreciated.

Re: Connecting qlikview to PostgreSQL with ODBC connector

Anonymous — Tue, 27 Sep 2016 15:06:26 GMT

Ok, so a colleague of mine approached me an "helped me out" with this.

One cannot leave the "Server" field blank, "localhost" was the correct answer to the previoursly blank field (I actually came up with that when explaining to him my situation)

Cheers~

Re: Connecting qlikview to PostgreSQL with ODBC connector

Anil_Babu_Samineni — Tue, 27 Sep 2016 17:31:03 GMT

What is the issue while connecting

Re: Connecting qlikview to PostgreSQL with ODBC connector

Anonymous — Wed, 28 Sep 2016 08:38:29 GMT

I cannot remember the code error atm and I am overloaded with work right now. I look forward to replicate the issue later and give you the details but since it is solved I had moved on and started working in the next issue