Gordon & Gotch Myriad Admin Guide
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
Not covered in this document.
Requirements: Windows XP or later
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)
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\.
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-server2.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]
- Allow saving password - checked
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]
- Allow saving password - checked (See ERROR 1 below)
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:
- Connection - REG_SZ - Data Source=<SERVER NAME>\<INSTANCE OF SQL SERVER NAME>;Initial Catalog=<DATABASE NAME>;Integrated Security=True;Persist Security Info=False;Asynchronous Processing=True;Application Name=Myriad
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
These are from 2007 and may or may not be fixed now.
If you don't select 'allow saving password' when configuring an ADO connection you get an error:
- 1st dialog says "OnError - Login failed for user myriad_user_1.'
- 2nd dialog of which says btnLaunch_Click - Object reference not set to an instance of an object - Launcher - at Launcher.Launcher.btnLaunch_Click(Object sender, EventArgs e)]
At every stage if you get a username/password wrong you get cryptic error messages and circular dialogs
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'.
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
If you don't have write access to the database: "Error #: 3027 - Desc.: Cannot update. Database or object is read-only. - Src.: DAO.TableDefs"]
- is the db frontend being accessed by another user than ...\...?
- you have to accept this hundreds of times and then says "Relinking completed succesfully"]