Gordon & Gotch Myriad Admin Guide

Introduction

Myriad consists of a server (the database and a COM+ object to handle credit card encryption) and a client (the application and .NET DLLs to handle email)

Web site: http://www.gordon-gotch.co.uk/

Support: support @ gordon-gotch.co.uk / 0845 8990 341

Server Setup

Not covered in this document.

Workstation Setup

Requirements: Windows XP or later

Per-Machine Initial Installation

1.1 Unless already installed, download and install Microsoft .NET Framework 3.5 Service pack 1 (Full Package) (includes .Net 2.0 and .Net 3.0) - http://www.microsoft.com/en-gb/download/details.aspx?id=25150

1.2 Run Microsoft Update and download any updates for .Net

1.3 Create a Myriad program directory %PROGRAMFILES%\GGPL\myriad\.

1.4 Copy the Myriad client program from \\db-server\myriad\client install\4.8 to %PROGRAMFILES%\GGPL\myriad.

1.5 Create an All Users desktop shortcut by navigating to All Users' Desktop, choosing New → Shortcut, point to "%PROGRAMFILES%\GGPL\Myriad\Launcher.exe", call it 'Myriad', (so that permissions are set for Everyone to run it)

Subsequent Program Updates

Delete the contents of %PROGRAMFILES%\GGPL\myriad\.

Copy the new Myriad 4.8 client program from \\db-server\myriad\client install\4.8 to %PROGRAMFILES%\GGPL\myriad\.

User Accounts

Per-User Initial Setup

You need to create an account for each person.

Note: Check the user you're setting up isn't already logged in otherwise you could lose the setup you're making here!

2.1 Run Myriad from the desktop shortcut. Choose Create.

2.2. At the DataLink Properties window carry out the following steps:

2.2.1 Choose 'Microsoft OLE DB Provider for SQL server' → Next

2.2.2 1. Select or enter a server name: db-server

2.2.3 2. Enter information to log on to the server - use a unique username and password for each user [these are managed in the Microsoft SQL server]

2.2.4 Select the database on the server: 'myriad_live'.

2.2.5 Select OK

You should be back at the Myriad launcher.

You now do the same but for the demo version of the database.

2.4 Choose Create

2.5. You will get the DataLink Properties window. Carry out the following steps.

2.5.1 Choose 'Microsoft OLE DB Provider for SQL server' → Next

2.5.2 1. Select or enter a server name: db-server

2.6.3 2.Enter information to log on to the server - use a unique username and password for each user [these are managed in the Microsoft SQL server]

2.6.4 Select the database on the server: 'myriad_demo'.

2.6.5 Select OK

2.8 You should be back at the launcher

[Now you have the registry key HKCU\Software\GGPL\Myriad\myriad_demo which can be deleted if anything has gone wrong and you need to start over. These are what it contains:

2.9.1 Run Myriad

2.9.2 Choose myriad_demo or myriad_live

2.9.3 Login with a Myriad username and password

2.9.4 Choose Launch

You should now be able to use Myriad

Issues

These are from 2007 and may or may not be fixed now.

ERROR 1

If you don't select 'allow saving password' when configuring an ADO connection you get an error:

ERROR 2

At every stage if you get a username/password wrong you get cryptic error messages and circular dialogs

ERROR 3

When choose 'Create', get OnError Login failed for user 'myriad_user_1'. We then have a myriad_live instance in the drop-down list when myriad first launches (despite the above error). Which username and password do we then use to login? Choosing this name from the drop-down or the blank one causes an OnError Login failed for user 'myriad_user_1'.

ERROR 4

If you forget to save the password during 'Specify Data Source', then choose 'details' you get into an endless circular dialogs asking for username/password and can't even logout

ERROR 5

If you don't have write access to the database: "Error #: 3027 - Desc.: Cannot update. Database or object is read-only. - Src.: DAO.TableDefs"]