Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC Connection Failed and Hidden Script

Hi.

I moved all tabs into hidden-script tabs, but the Main Tab which has the connection definition.

When I pressed the Reload button. I got Error messages:

Each table from database the error showed: ODBC Connection Failed.

Each resident table error showed was: Field not found.

Can't I hide all my scripts, or can I?

3 Replies
vgutkovsky
Master II
Master II

Gil, I think the confusion is the order of the hidden script. Hidden script tabs are always executed first (before the Main tab). So you'd need to move your connection string into the hidden script, most likely.

Regards,

Vlad

Greg_Williams
Employee
Employee

I agree with Vlad G. here. Hidden Scripts are run first, then the viewable scripts. You can create include statements to hide the ODBC connection (truly) and the script (as another thought).

#include filename;

fkeuroglian
Partner - Master
Partner - Master

As Greg and Vlad say, try to put out the string conection  would be a good option and more secure

you can do some like this

SET Path_ConnectionString='../6_Seguridad';

$(must_include=$(Path_ConnectionString)/ConexionPP.txt)

the ConexionPP.txt will have the string conecction and would be in the 6_Seguridad folder in the root folder.

Good Luck

Fernando