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
Creating the features in the GSA allows me to store the connection information and will refresh the data (but not store the password). But I was trying to avoid doing it with the GSA if I can.
Saving Passwords:
I believe that you can accomplish what you desire by setting up the DB connection within the GSA, and launching your Bentley Map session from said XFM schema's workspace. This may or may not also require creation of spatial features within the schema.
Sorry Ian, it's my mistake, we cannot save the password of an Oracle connection. As said Jon Summer: "That would, potentially, breach security" and Oracle do not permit that....
I'm so sorry, I didn't mean to lead you on.
No offence.
Sebastien
Hi Sebastian,
I have saved the .orax file from Bentley Map, but it is not saving the connection password. Can you tell me the XML property that should be set.
Hi Ian,
You can save your Oracle connection settings as a .ORAX file in the interoperability windows. With this file, you don't need to key-in any user name and password each time. It stills save into the file. You can also define an Oracle database connection through schema in GSA.
This is extract from Bentley Map V8i Help file :
Working with a Defined Spatial Project A spatial project is defined in the Bentley Geospatial Administrator by the administrator who registers features found in an Oracle database. If the Oracle source is open in the Administrator, you can open the source in Bentley Map through the Interoperability dialog box.
To import with a spatial project
HTH,