topic ODBC Connection Failed and Hidden Script in QlikView

ODBC Connection Failed and Hidden Script

Mon, 30 Jun 2014 20:14:23 GMT

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?

Re: ODBC Connection Failed and Hidden Script

vgutkovsky — Mon, 30 Jun 2014 21:33:30 GMT

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

Re: ODBC Connection Failed and Hidden Script

Greg_Williams — Mon, 30 Jun 2014 21:55:33 GMT

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;

Re: ODBC Connection Failed and Hidden Script

fkeuroglian — Tue, 01 Jul 2014 02:51:08 GMT

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