Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Everything E3D

TABLE OF CONTENTS

SQL Server

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedFeb 20, 2026
  • 4 minute read

Use AVEVA Clash Manager Project Connections window to create an SQL server hosted project.

Create Project

Creates a new SQL server hosted project to hold the clash information.

Note: Normally only one connection to a database is necessary.

Add Connection

Adds details of an existing SQL server database.

Edit Connection

Changes the connections parameters.

Recreate/Upgrade Database Objects

Use to repair lost database views, indexes or upgrade a non-Unicode project to Unicode.

From the grid pane of the AVEVA AVEVA Clash Manager Project Connections window populated with a list of connections, use the right click menu to:

  • Delete - deletes the selected connection record from the AVEVA Clash Manager configuration file (does not delete any clash data from the SQL Server database)

  • Add - restores the connection record.

    Note: Details of configured projects are stored in a AVEVA Clash Manager configuration file in the Project DFLTS folder: %PROJDFLTS%\clashManager.xml

Delete Project

Deletes the SQL Server data.

Copy Connection

Copies the selected connection.

Use the AVEVA Clash Manager Select Host Database window to select an SQL host sever.

  1. Use the AVEVA Clash Manager SQL Server Instance window to select an SQL Server Instance.

  2. Select from the drop down populated with a list of available SQL server host/instances.

    Note:
    Where all instances for a particular host are not show, the instance can ne entered manually, then refresh.

  3. Enter the login details of a user with DBA rights, that is rights to create another user, rights to create tables, indexes and so on.

  4. Use the AVEVA Clash Manager SQL Server Database window to select an SQL Server Database.

  5. Select an existing SQL Server Database found on the selected host instance, from the Database pane.

    Note:
    The necessary SQL Server Database must already have been created using the SQL Server Management Studio.

  6. Select the Collation appropriate to the local language.

  7. Use the AVEVA Clash Manager SQL Server Database Connection Configuration window to select an SQL Server Connection Configuration.

    The details of the selected SQL Server and connection configuration are displayed.

    The major parts of AVEVA Clash Manager comprise the UI (displaying the clash report) and the clasher interface which includes the run process (which runs desclash) and the loader (which loads clash data into the SQL Server/Oracle database). These are separate processes each of which require separate database connections.

    The UI uses ADO.NET, three of the available protocols are supported: SQL OLE the ADO clash interface supports the OLE provider Sq101eDB.1

  8. If required the Command Timeout can be modified during the life time of a project if a SQL Server timeout occurs during the load process.

The Connection Alias identifies the particular record where more than one connection is configured, a Login window is displayed where the alias is the identifier. The Login window is also displayed if the automated login process fails as a result for example - a password change on the server.

Note:
A FREE user or a member of the DESADMIN team has an opportunity to edit the connection details by selecting Connection Wizard on the Login window.

The AVEVA Clash Manager Database Login details relating to the connection configuration are displayed in the AVEVA Clash Manager - AVEVA Clash Manager Database Login window.

  1. Enter in the New Database Login part of the AVEVA Clash Manager - Clash Manager Database Login window the Username and Password of the new SQL Server user that will own the tables, indexes, clash data and so on.

    The default Username is PCLAMxxx and the password is PWxxx, where xxx is the 3D model project code.

    Note:
    The SQL Server user password can be changed externally, in that case, select Edit Connection from the AVEVA Clash Manager - Clash Manager Project Connections window to update the AVEVA Clash Manager configuration.

  2. Populate the AVEVA Clash Manager - 3D Model Login window with the login details for a 3D model.

  3. Enter a 3D Model username and password which will be used to initiate the TTY sessions which will run desclash and load the resulting data. The TTY sessions run with the READONLY flag.

  4. Use the AVEVA Clash Manager - Optional Clash Manager Project Details window to enter the Project Title, Project Number and Client output when a clash report is saved using Save As.

    Display units can be fixed to display metric, finch only or user preference.

  5. Use the AVEVA Clash Manager - Confirmation window to review details before selecting Finish to initiate creating the project.