Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I found solution of my problem. I had to upgrade my PostgreSQL from ver.8 to ver.9.
you should install ODBC driver PostgreSQL for connect to qlikview
.
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.
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.
Thanks...
Worked for me
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??
You can send a example query and ole db or odbc conection?