ODBC PostgreSQL modify database name

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Using internal tools in scripting window, qlikview write this code to connect to a database using ODBC and postgresql :

ODBC CONNECT32 TO PostgreSQL30 (XUserId is xxx, XPassword is xxx);

SQL SELECT *

FROM thedatabase."schema"."table";

If thedatabase is the same configured in the ODBC window everything is fine and I can load data.

Unfortunatly if I change thedatabase and set another databasename (which I'm sure exist) I get a odbc cross database references error.

I tried many solutions but no one works for me

How can I set another database name in scrit which is not one that is configured in ODBC tools ?

Thanks in advance and sorry for my poor english.

Re: ODBC PostgreSQL modify database name

Fri, 04 Nov 2016 15:45:19 GMT

Gotcha !

ODBC CONNECT32 TO [PostgreSQL30;DATABASE=thedatabase;] (XUserId is xxx, XPassword is xxx);

SQL SELECT *

FROM thedatabase.schema.table;