Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

The tables are not shown in the form

Mahi9119Nov 7 2022

I have created tables in the work space, those are not shown in the oracle apex application inside a form.
please find attached screenshot for reference.
Tables not displayed in apex.docx (483.71 KB)

Comments

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
http://support.microsoft.com/?kbid=209502

Regards,
Turloch

Oracle Migration Workbench Team
513298
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).

Shaun Burton
IS Solutions Consultant
Alipro USA LLC
513298
If you are using a System DSN, you can also edit the registry to include the password since it is stored as plain text in the key:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<dsnname>\Password

Regards

Shaun Burton
IS Solutions Consultant
Alipro USA LLC
843208
could you give detail instruction for add this step..
1 - 4

Post Details

Added on Nov 7 2022
4 comments
333 views