Refreshing Oracle Data

Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?

Also how can you save the Oracle connection user name and password in a DGN?

Cheers Ian

Parents
  • Ian:
    Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?

    What do you mean by 'refresh the Oracle data'?

    Ian:
    Also how can you save the Oracle connection user name and password in a DGN?

    That would, potentially, breach security. If your security can tolerate local storage, then write a VBA macro that preserve the Oracle login settings.

    Regards, Jon Summers
    LA Solutions

     
    Regards, Jon Summers
    LA Solutions

Reply
  • Ian:
    Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?

    What do you mean by 'refresh the Oracle data'?

    Ian:
    Also how can you save the Oracle connection user name and password in a DGN?

    That would, potentially, breach security. If your security can tolerate local storage, then write a VBA macro that preserve the Oracle login settings.

    Regards, Jon Summers
    LA Solutions

     
    Regards, Jon Summers
    LA Solutions

Children
  • Jon Summers:
    Ian:
    Is there a method to automatically cause a DGN to refresh the Oracle data when it is opened with PowerMap (or Bentley Map)?

    What do you mean by 'refresh the Oracle data'?

    I mean that when you open a DGN the data may not be in sync with the Oracle database (someone may have changed the Oracle database and these changes may not be reflected in the DGN), and the data may need requerying.  I want to do the requery process automatically.

    Jon Summers:
    Ian:
    Also how can you save the Oracle connection user name and password in a DGN?

    That would, potentially, breach security. If your security can tolerate local storage, then write a VBA macro that preserve the Oracle login settings.

    Can the user name and password be stored in the connection XML file (I can secure the file using other methods)?

    Cheers Ian