Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

ODBC Connection Failed and Hidden Script i

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?

1 Solution

Accepted Solutions
Employee
Employee

Re: ODBC Connection Failed and Hidden Script i

If you load Excel tables using "Load", then it doesn't matter. They don't use any CONNECT. (But it is also possible to use ODBC to load Excel tables. Then of course you use SELECT and you need a CONNECT before the SELECT.)

HIC

4 Replies
Employee
Employee

Re: ODBC Connection Failed and Hidden Script i

You need to move your CONNECT statement to the hidden script too. It must be before any SELECT.

HIC

Not applicable

Re: ODBC Connection Failed and Hidden Script i

and what about the tables loaded from excel?

Employee
Employee

Re: ODBC Connection Failed and Hidden Script i

If you load Excel tables using "Load", then it doesn't matter. They don't use any CONNECT. (But it is also possible to use ODBC to load Excel tables. Then of course you use SELECT and you need a CONNECT before the SELECT.)

HIC

praveenavelagap
Contributor III

Re: ODBC Connection Failed and Hidden Script i

Qlikview execution is always from left to right tabs. Hidden scripts will be in previous to it, considered as 1st.

So, connection should be specified first to load tables where they are from.

And there is always only one connection to data source is possible,  it gets disconnected when you specify  disconnect command (or) when connected to new source, this way you can connect to one more new data source.

recommended: get connection to data source,load all required tables from it then, you may connect to one more new datasource.

Community Browser