topic Re: ODBC Load being ignored in QlikView

ODBC Load being ignored

Sat, 21 Feb 2015 00:01:21 GMT

I am making several connections to retrieve data...some are OLEDB connections to SQL data source, one is to SalesForce.com, some are .xls files. These are working fine.

Now I'm trying to connect to an Access DB vie an ODBC connection. I have the connection statement, with a Load statement followed by a SQL statement followed by a Drop Fields statement. However when I run the script it doesn't load...it just gets ignored. It seems like whether I place it in a separate tab or in the same tab as other statements it either gets ignored or gives an error that the connection can't be made.

What could be going on? What should I try to do? When I run it by itself it is successful.

Thanks! Dan

Re: ODBC Load being ignored

Gysbert_Wassenaar — Sat, 21 Feb 2015 10:48:40 GMT

Did you end the sql statement with a semicolon ; ?

Re: ODBC Load being ignored

Mon, 23 Feb 2015 18:49:47 GMT

Yes...all code has appropriate semicolons, so it appears.

Re: ODBC Load being ignored

Colin-Albert — Mon, 23 Feb 2015 18:54:36 GMT

Only one ODBC connection can be active at a time. If you have several connections, you need to add the connect statement, and then have the relevant load/select statements after that connection. Then have the next connect statement and load/selects etc.

If you are seeing an error, do you have the correct login details?

Can you review the document log to see more details of the error that is reported.

Can you post the details of the error here?

Re: ODBC Load being ignored

Mon, 23 Feb 2015 18:55:29 GMT

Can you please send us the script, to have look at it.

Re: ODBC Load being ignored

Mon, 23 Feb 2015 18:59:08 GMT

I'm not getting an error at this time. I have one tab that has two OLEDB connections, and I have a DISCONNECT statement at the end of each one. THen I have 3 more tabs in the script, each one just getting an .xlsx file. Then on the last tab I have this ODBC connection that just gets ignored. Perhaps I should try moving it onto one of the other tabs?

Re: ODBC Load being ignored

Mon, 23 Feb 2015 19:01:48 GMT

When I moved the ODBC connection and code to the 1st tab with the OLEDB connections, I get an error that says "ODBC Connection failed", but doesn't give any explanation...just the SQL code. I used DISCONNECT after the OLEDB connections above.

Re: ODBC Load being ignored

Colin-Albert — Mon, 23 Feb 2015 19:04:25 GMT

Have you tried removing the Disconnect statement?

Disconnect is optional - the connection is only active in the script until the next Connect statement is reached.

Re: ODBC Load being ignored

Colin-Albert — Mon, 23 Feb 2015 19:07:45 GMT

Have you tried stepping through the script using Debug?

Do you have a load / Select statement after the final ODBC connection?

QlikView does sometimes forget the active connection, so does not prompt you for tables and fields when you click on the select button. Try adding the connection using the connect button again and then select the Access fields for your load script.

Re: ODBC Load being ignored

Anonymous — Tue, 24 Feb 2015 02:39:40 GMT

Try ODBC connection outside QV.

Verify if are using 32 or 64 bits version.