Problem download from PostgreSQL

[#1]

Hi.

I can't download data from PostgreSQL30 database (I'm using ODBC). QlikView gives me a such error:

Script error

SQL##f - SqlState: 0A000, ErrorCode: 7, ErrorMsg: ERROR: cross-database references are not implemented: "tabl.public.moron";

Error while executing the query

SQL SELECT *

FROM Tabl."public".moron

Connecting test to PostgreSQL30 is succesful and I can see all tables in my db.

Also, I can import data from PostgreSQL db in MS Excel and MS Access files with out any problem.

Does anybody know, how this problem is solved?

Thank you.

[#2]

I found solution of my problem. I had to upgrade my PostgreSQL from ver.8 to ver.9.

[#3]

you should install ODBC driver PostgreSQL for connect to qlikview

.

[#4]

I had already reinstalled ODBC driver PostgreSQL three times and I had always got the same error. but when I installed ver.9, my problem was solved.

[erivera10]

@billknilton

I found a solution for this error, reinstall, reboot, did many things and many assumptions methods, but what worked for me after analyzing the code I found the error.

When you load a table shows you the code by default.

SQL SELECT *

FROM testing."public"."sale_order_line";

The solution is as follows:

SQL SELECT *

FROM "public"."sale_order_line";

Good luck.

Encontré una solución para este error, reinstale, reinicie, hice muchas cosas y muchos supuestos metodos, pero lo que me funcionó después de analizar el código encontre el error.

Cuando tu cargas una tabla te muestra este código por default.

SQL SELECT *

FROM testing."public"."sale_order_line";

La solución esta así:

SQL SELECT *

FROM "public"."sale_order_line";

Buena suerte.

[Anonymous]

Thanks...

Worked for me

[jananireddy]

Hi, i am using postgreSQL 9.4 and i am getting the following error when i run load data

The following error occurred:

SQL##f - SqlState: 0A000, ErrorCode: 7, ErrorMsg: ERROR: cross-database references are not implemented: "fincluez.fincluez.casanonod";

Error while executing the query

Query for the same table (casanonod) from postgreSQL editior works fine, it give me an error only when it is called from qlik sense

Any suggestion for this??

[erivera10]

You can send a example query and ole db or odbc conection?