Hi,
As a part of checking the DSN connectivity, we tried to import table definitions using Designer
Right click Table Definition->ODBC->DSN window
However the for one of the database it did not list any tables. i got a message saying 'No Match Found!'.
The DSN connectivity was done at the same time in exactly the same way for two databases db1 and db12 . However, it failed only for db12.
Also we checked the database connectivity to the databases using DB2 CLP using the same id and password used for import & that was fine.
DSN seems to have been configured correctly because i can see it for both the databases in the drop-down list.
We had made necessary changes in .odbc.ini & uvodbc.config files at the DSHOME and Project level.
Thanks,
Renita
Unable to import table definitions using Ascential 7.5
Moderators: chulett, rschirm, roy
Are you certain that the user you are using to connect has SELECT privileges on both databases and that you don't have the "Filter" set incorrectly?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>