Unable to import table definitions using Ascential 7.5

Renita · Post by **Renita** » Thu Mar 02, 2006 4:33 am

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

ArndW · Post by **ArndW** » Thu Mar 02, 2006 4:37 am

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?

Renita · Post by **Renita** » Mon Apr 10, 2006 12:56 am

Hi,
The import was failing for job executibles. I excluded it in the import and it ran fine.Later i did a mass compile for all jobs in the system

Thanks! : )

Renita · Post by **Renita** » Mon Apr 10, 2006 1:02 am

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.

Any help on this!

ririr · Post by **ririr** » Tue Apr 28, 2009 3:28 pm

Renita,

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.

Any help on this!