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.
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.
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?
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.
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.