I am working on an application which uses an oracle database as backend. The aplication uses a login dialog in
so my application knows the credentials for the oracle database. I use a a drawing-template which has a databaselink in it. This points to a UDL-file in 'Data Linls'. If i add the Credentials to this file and set the Parameter Persist Security Info=True the Credentials are ignored. So i thought i can avoid the additional loginprocesses if I add the following code:
It seems that there are 2 connections and so 2 credentials are needed, may be one for CAO and the one for ADO.NET or FDO if you are using it. I don't know if the two connections are required for your workflow, but it's not uncommon if you need to access 2 different kind of data on 2 different datasources.
Persist Security Info=True , only means that the credential info it's retained after the connection is established, and so you can recover that info from the connection, usually you set it to false for security. But the credentials are needed every time you need a connection, no matter if it's set to true or false.