Workstation Access to Argos
These tasks need to be completed for each workstation that will be using the Argos application.
- Install the prerequisites
- Create an ODBC DSN
- Create the Desktop shortcut with database connection information
If a new workstation is being added to an established Argos network e.g. a new staff member has been employed), you will also need too:
- Add the staff member to the list of users in the application via the menu option
– Control | Edit/View Staff Codes
Notes:
If using NT Authentication, the login to Argos MUST be identical to their windows login. Ignore the password prompt when saving the new user.
If using SQL Authentication, a password must be entered for the staff member. - Add the staff member to the appropriate user groups:
- NT Authentication
- Add the user the Windows ‘Argos User’ group
- Instructions contained in the section ‘creating the new windows group’ may assist with this. Note: the existing group should be edited, not a new one added though.
- SQL Authentication
- Add the user to the SQL Server ‘Logons’
- See Section SQL Authentication
Create an ODBC DSN
The ODBC connector is located separately depending on whether the workstation has a 32 bit or 64 bit operating system. There is no difference to the setup required once in the file.
32 bit Operating Systems
Control Panel | Administrative Tools | Data Sources (ODBC)
64 bit Operating Systems
C:\Windows\SysWOW64\odbcad32.exe
Double click on the .exe file to open. A dialog similar to below will be presented:
1. Change to the System DSN Tab
2. Click [Add] to present the below dialog:
3. Select SQL server (you may have to scroll down to find this option)
4. Press [Finish]. The below dialog will now appear:
5. Enter a name for the data source
Note this down, as it will be the DSN connection name required for the shortcut.
For ease of recollection, we recommend using the same name as the database or ledger that is being connected too.
6. Enter a description if required.
7. Drop down to select the SQL server that the Argos database is located on
The completed dialog should appear as similar to below:
8. Click [Next]
A dialog similar to the below will be presented:
9. Follow the instructions below for your specified server access
NT Authentication
Accept the default values and click [Next]
SQL Server Authentication
Click on the button next to ‘SQL Server authentication…”
Enter your SQL Server Login ID and Password
Click [Next]
The below dialog will be presented:
10. Check the box next to ‘Change the default database to:’
11. This will open up the combo box for selection; drop down to locate the ledger database.
The completed dialog will be similar to the below:
12. All other default values can be accepted, click [Next]
13. All default values on this screen (see below) can be accepted, click [Finish]
The below dialog will be presented:
14. Click [Test Data Source]
The below message should then be seen:
15. If the test was successful, Click [OK] on the data source test message, and the Server Setup dialog. The ODBC is now created
- If the test failed, re-access the ODBC exe. On the system DSN tab, select the ODBC set up and press [Configure]. Use this to check your settings are correct.
- If the test still fails, you may need to re-examine the setup of the server access / permissions, and ensure these are as expected.
Create a Desktop Shortcut
1. Right click on an empty area of the desktop and select New | Shortcut from the pop up menu:
2. The below wizard will be displayed:
Use the [Browse] button to navigate to the application server and locate the AFSFin.exe file. This is located in the ArgosApps\AFS folder.
Note: if the executable file is installed on an application server you should use UNC paths.
Click [Next]
3. Type a name for the Shortcut. This would usually be the name of the ledger.
4. Click [Finish]
5. A new shortcut will appear on the desktop
6. Right Click on the shortcut and select ‘Properties’
7. A dialog similar to the below will open:
In the ‘Target’ field, add a space after the file name and then the text
DSN=<<Name>>
<<Name>> is the one noted at step 5 of the creation of the ODBC DSN. Usually the database or ledger name.
In the ‘Target’ field, add a space after the file name and then the text:
DSN=<<Name>>;uid=<<sqluserid>>;pwd=<<sqlpassword>>
Notes:
<<Name>> is the one noted at step 5 of the creation of the ODBC DSN. Usually the database or ledger name.
<<sqluserid>> is the sql user login code for the user, that the connection will run under
<<sqlpassword)the password of the sql user specified above
There should be no spaces added to the DSN String. (see below completed dialog for example)
9. In the ‘Start In’ field, enter the file path to the executable. (This is usually the same as the Target file without the AfsFin.exe)
A completed dialog will appear as below:
10. Use the [Open File Location] button to ensure that the executable file can be found.
11. Click [Apply] and then [OK]. The DSN will now be saved.
12. You should now be able to run the application by double clicking on the icon.
13. The application will then open as below:
14. Enter your logon code and password and press [OK].