Database Connection UDL File With Relative Path

[Cam_Roots]

Hi All,

I am using property loader to retrieve test settings from the database. I specify the database to read from using a .udl file.

When opening a database connection (using Open Database step type) I am able to specify the location of the .udl file as follows:

"FILE NAME=C:\\Development\\IW_EST_2\\TesterSoftware\\TS\\Database\\DatabaseConnection.udl;"

This works fine for now. However, I am not developing on the computer which the sequence will be deployed on. It is for this reason that I would like to use a relative path.

Is it possible to do this? If so, how?

Many thanks,

Cam.

[PhillipBrooks · Accepted solution]

You can use a UNC naming convention to specify the location of the UDL.

A UNC replaces a drive letter with a machine name and share name.

Example of a connection string I use every day:

"FILE NAME=\\\\netapp1\\shared\\STE\\SPOTS.udl"

(note the quadruple backslashes in front of the machine name)

[Cam_Roots]

Thanks Phillip