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.
Hi,
The import is still failing using DSN ODBC!
When i bind the DSN i get error
Package creation failed!: Specified security mechanism, (Unknown), is not supported by server.
Were you able to resolve this issue? I am getting the same error.
Thanks,
Renita wrote:Hi,
The import is still failing using DSN ODBC!
When i bind the DSN i get error
Package creation failed!: Specified security mechanism, (Unknown), is not supported by server.