Tables not visible in select statement wizard

Anonymous — Sun, 19 Nov 2017 20:34:09 GMT

Looking for some help as I have run out of ideas.

I have an ODBC connection to a MS SQL 64 bit database using an account which is a sysadmin on that database.

Permissions look good and if I manually script the select statement I can sucessfully read data.

My problem is when I try to use the select statement wizard none of the user created tables in user created schema's are visible. I can see all system tables fine but none of the tables in other schemas.

As I said I can manually script the statement to these tables and read data fine but I don't want to have to do this for every table.

Does anyone have any ideas on this?

Thanks

Re: Tables not visible in select statement wizard

marcus_sommer — Mon, 20 Nov 2017 08:01:24 GMT

It's not a solution else just a workaround which I use sometimes if I couldn't see the tables or even access the database per wizard:

select top 1 * from table;

and then creating a listbox with $Field, export the listbox to excel and doing some adjustments with expressions like adding quotes/brakets and comma's or manually like removing or renaming fields and copy & paste it back. Usually it takes just 1 or 2 minutes.

- Marcus

topic Tables not visible in select statement wizard in QlikView

Tables not visible in select statement wizard

Re: Tables not visible in select statement wizard