Empty field names with QlikView and PostgreSQL 8.4

From: Hilbert Mostert <hilbert(at)provelu(dot)nl>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Empty field names with QlikView and PostgreSQL 8.4
Date: 2010-05-25 14:56:27
Message-ID: 4BFBE51B.9010108@provelu.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

I am having troubles with QlikView and PostgreSQL 8.4. I can view table
names but not the columns from the tables. The psqlodbc_***.log shows
the following error every time when I select a different table:

[6.360]couldn't convert the type 21 to SQL_C_BINARY
[6.360]STATEMENT ERROR: func=SC_fetch, desc='', errnum=14,
errmsg='Received an unsupported type from Postgres.'

I have red through the source code and saw that the type 21 is actually
an PG_TYPE_INT2 field.

Did anyone else have this problem and if so, what is the solution? If
not, what are the following steps?

Regards,

Hilbert Mostert

Browse pgsql-odbc by date

  From Date Subject
Next Message Ken Sell 2010-05-28 16:57:27 Question about building for Windows
Previous Message noreply 2010-05-24 23:54:56 [ psqlodbc-Bugs-1010827 ] ODBC driver not parsing comment correctly