SQL - Missing tables?

[#1]

Hi, I'm starting with QLIK and doing some test where I'm connecting via ODBC to a database, but when I'm selecting data, I'm unable to find one particular table. If I go via SQL management Studio and with exactely the same SQL user, I can see this table...

I even got another identical database under the same instance and schema, where I can find this particular table, but on this DB it doesn't show up on the "Add Data" menu.

What can be the reasons for this?? Any hints from more experienced users??

Thanks in advance for your help!

Carlos Silva

[tresesco]

If possible try to connect with OLEDB rather than ODBC.

[sinanozdemir]

Make sure to choose the correct schema in the create select statement window:

And also check the appropriate check boxes as well.

[maxgro]

try to paste the query that work in SQL Management Studio in QlikView editor

SQL

select ....... from ..........;

reload and post the error

[#5 · Accepted solution]

Thanks for your tips. Don't know what happened but the table is available now. I suspect it was "missing" because i now realized that when using the scroll Wheel it jumps lines/tables from one window to another.

Thanks,

Carlos Silva

[maxgro]

ok, please close the thread marking (I think your answer) correct and/or helpful answers, thanks