Versions Compared

Version Old Version 2 New Version 3
Changes made by

Julie Doyle-Whitelock (Deactivated)

Julie Doyle-Whitelock (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Installs the native client for Microsoft SQL Server. This driver allows the client workstation to connect to the Microsoft SQL Server.Important:

Warning

If Microsoft SQL Native Client is already installed, proceed to Step 2 - ODBC DSN Configuration - Framework. If unsure, re-install the software.

Install - Microsoft SQL Native Client

  1. Open Windows Explorer.

  2. Browse to: \[fw folder]\Setup\Database - MSSQL\Microsoft - SQL Server Native Client Driver\

    Info
    Note:
    Install the correct Microsoft SQL Server Native Client Driver (either 2005 or 2008) based on the version of Microsoft SQL Server installed on the server.


  3. Double-click the relevant setup file. The Microsoft SQL Server Native Client installation will begin.
  4. Click the Next The Licence Agreement step will be displayed.
  5. Select I accept the terms in the licence agreement.
  6. Click the Next The Registration Information step will be displayed.
  7. Enter the registration details.
  8. Click the Next The Feature Selection step will be displayed.
  9. Click the Next The Ready To Install the Program step will be displayed.
  10. Click the Install button to begin the installation.
  11. Click the Finish button to complete the installation.

...

Provides Framework with the connection to read and write from the database.Important:

Warning

If Framework ECM and Framework Licence databases have already been configured, please proceed to Step 3 - ODBC Configuration - Framework Integration.


Warning

Microsoft 64-Bit Operating Systems include two ODBC Data Source Administrator executable files.

Depending on the operating system, use the following to open the correct ODBC Data Source:

On 32-Bit Operating Systems: Use either:
Start Menu > Control Panel > Administrative Tools > Data Sources (ODBC)
OR
\\%SystemRoot%\system32\odbcad32.exe (e.g., C:\Windows\system32\odbcad32.exe).

On 64-Bit Operating System: Use:
\\%SystemRoot%\SysWOW64\odbcad32.exe (e.g., C:\Windows\SysWOW64\odbcad32.exe).

...

  1. Open Data Sources (ODBC).
  2. Select the System DSN
  3. Click the Add The Create New Data Source dialog will be displayed.
  4. Select SQL Native Client 10.0.
  5. Click the Finish The Create a New Data Source to SQL Server dialog will be displayed.
  6. Enter the following details:
    • Name: FworkSQLEcm
    • Description (optional): Enter a description for the database connection. For example, Framework ECM.

    • Server: Select the SQL Server from the Server drop-down list.
      OR
      Enter the SQL Server name.

      Note:
      Info
      If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS


  7. Click the Next
  8. Click the Next
  9. Tick Change the default database to.
  10. From the drop-down list select: FworkSQLEcm
  11. Click the Next
  12. Click the Finish The ODBC Microsoft SQL Server Setup dialog will be displayed.
  13. Click the Test Data Source...
  14. If successful, click the OK
  15. Click the OK The ODBC Microsoft SQL Server Setup dialog will close.
  16. Click the OK The Data Sources (ODBC) dialog will close.

...

  1. Open Data Sources (ODBC).
  2. Select the System DSN
  3. Click the Add The Create New Data Source dialog will be displayed.
  4. Select SQL Native Client 10.0.
  5. Click the Finish The Create a New Data Source to SQL Server dialog will be displayed.
  6. Enter the following details:o Name: FworkSQLLic
    1. Description (optional): Enter a description for the database connection. For example, Framework

  7. Licence.Server: Select the SQL Server from the Server drop-down list.
    OR
    Enter the SQL Server name.

    Info
    Note:
    If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS


  8. Click the Next
  9. Click the Next
  10. Tick Change the default database to.
  11. From the drop-down list select: FworkSQLLic
  12. Click the Next
  13. Click the Finish The ODBC Microsoft SQL Server Setup dialog will be displayed.
  14. Click the Test Data Source...
  15. If successful, click the OK
  16. Click the OK The ODBC Microsoft SQL Server Setup dialog will close.
  17. Click the OK The Data Sources (ODBC) dialog will close.

...

  1. Open Data Sources (ODBC).
  2. Select the System DSN
  3. Click the Add The Create New Data Source dialog will be displayed.
  4. Select SQL Native Client 10.0.
  5. Click the Finish The Create a New Data Source to SQL Server dialog will be displayed.
  6. Enter the following details:
    • Name: FworkSQLIntMap
    • Description (optional): Enter a description for the database connection. For example, Framework Integration Mapping.

    • Server: Select the SQL Server from the Server drop-down list.
      OR
      Enter the SQL Server name.

      Note:
      Info
      If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS


  7. Click the Next
  8. Click the Next
  9. Tick Change the default database to.
  10. From the drop-down list select: FworkSQLIntMap
  11. Click the Next
  12. Click the Finish The ODBC Microsoft SQL Server Setup dialog will be displayed.
  13. Click the Test Data Source...
  14. If successful, click the OK
  15. Click the OK The ODBC Microsoft SQL Server Setup dialog will close.
  16. Click the OK The Data Sources (ODBC) dialog will close.

...

Installs a set of common software tools used by the Framework Product Suite.

Info

...

If installing on Microsoft Windows Vista or above, the User Account Control (UAC) Consent prompt may be displayed.
  1. Open Windows Explorer.
  2. Browse to: \[fw folder]\Setup\Insula Software Core Components\v16.2\
  3. Double-click setup.exe. The Insula Software Components installation will begin.
  4. Click the Next The Licence Agreement step will be displayed.
  5. Select I accept the terms in the licence agreement.
  6. Click the Next The Customer Information step will be displayed.
  7. Enter User Name and Organisation
  8. Select Anyone who uses this computer (all users).
  9. Click the Next The Setup Type step will be displayed.
  10. Select Complete.
  11. Click the Next The Ready To Install the Program step will be displayed.
  12. Click the Install button to begin the installation.
  13. Click the Finish button to complete the installation.

Step 5 - Install Framework Integration

...

Info
If installing on Microsoft Windows Vista or above, the User Account Control (UAC) Consent prompt may be displayed during the installation.
  1. Open Windows Explorer.
  2. Browse to: \[fw folder]\Setup\Framework Integration\vx.x.x\Setup\ (where x.x.x refers to the latest version of Framework Integration).
  3. Double-click Framework Integration.msi. The Welcome step will be displayed.
  4. Click Next . The Licence Agreement step will be displayed.
  5. Select I accept the terms in the licence agreement.
  6. Click Next. The Customer Information step will be displayed.
  7. Enter User Name and Organisation
  8. Select Anyone who uses this computer (all users).
  9. Click Next. The Setup Type step will be displayed.
  10. Select Complete.
  11. Click Next. The Ready To Install the Program step will be displayed.
  12. Click Install to begin the installation.
  13. Click Finish to complete the installation.

...

Step 6 - Test Framework Integration

Tests the installation of Framework Integration.

Start Framework Integration

  1. Start Framework Integration (Start > All Programs > Insula Software > Framework Integration).

    Tip: 
    Tip

    Double-click the Framework Integration desktop icon.


  2. Log on to the system.

Step 7 - User Acceptance Tests

The following is a list of view only tests that should be performed after installing the application.


Screen/View
Menu Path
Completed
Start Framework Integration

Log in as a user other than a super-user