In DTS, you can either copy a whole table or choose the columns you want. The Copy Table option correctly displays the Z schema name and works. Query Builder doesn't show the Z schema name and omits it from the query it generates. As a result, the SQLPrepare call Query Builder makes fails with "base table or view not found." To work around this problem, add no_schema=1 to your ODBC data source in odbc.ini.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
