This content has been marked as final. Show 4 replies
When creating the link tables there is a Save Login ID And Password Locally check box. Beyond checking this checkbox there appears to be no configuration by default (checked against 9iR2 and access2003).
Some details of how to manage this feature are available in the following URL
Oracle Migration Workbench Team
This is not terribly secure, unless the user does not have access to the ODBC data source administrator - but you can specify USERNAME/PASSWORD in the ODBC User ID field when configuring your DSN. This works, but of course the password becomes available to anyone who can access the ODBC datasource administrator and see the DSN in question. (Although I believe that if you do not have Administrator rights, you cannot edit System DSN information - so that might be a possible solution).
IS Solutions Consultant
Alipro USA LLC