Error when importing an Iseries table

[jorgeVal]

I have made a connection by ODBC to an Iseries database, in some tables I get this error when trying to open them: Error: The table has not visible columns and can not be queried. The tables are identical in the Iseries and some I can open them and others I can not. Do you know what I can do? Thank you

[v-juanli-msft]

Hi @jorgeVal 

Please check if any difference between those issued tables and other tables.

Verify the data source credential set for the data source in desktop has sufficient permission to access the Iseries database.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jorgeVal · Accepted solution]

hello v-juanli-msft

I have already found the solution, the problem is in the version of the OS of the Iseries with which the files were compiled, recompile the tables to which I did not have access and I can already access them.

Thanks