Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC PostgreSQL modify database name

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.

1 Reply
Not applicable
Author

Gotcha !

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

SQL SELECT *

FROM thedatabase.schema.table;