SQL Server

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

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

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

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

The SQL Server Instance must have been created with a case-insensitive collation.

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

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.

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

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

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

Select a case-sensitive collation for the ClashManager project which is appropriate to the local language.

Note:
That there are two distinct collations used, one for the server instance and one for the project. The collation of SQL Server Instance must be case-insensitive, Latin1_General_CI_AS is a suitable choice. The collation used when creating a project should be case-sensitive as the underlying application is case-sensitive.

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

The major parts of 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

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 Clash Manager Database Login details relating to the connection configuration are displayed in the Clash Manager - Clash Manager Database Login window.

Enter in the New Database Login part of the 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 Clash Manager - Clash Manager Project Connections window to update the clash manager configuration.

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

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.

Use the 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.

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