Forum Discussion

jorgeVal's avatar
jorgeVal
Frequent Visitor
7 years ago
Solved

Error when importing an Iseries table

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 iden...
Need Help
  • jorgeVal's avatar
    jorgeVal
    7 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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's avatar
jorgeVal
Frequent Visitor
7 years ago

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