Difference between revisions of "Workstation Installation Instructions"

From Agency Systems Wiki
Jump to navigation Jump to search
Line 1: Line 1:
[[Category:Installation]][[Category:Pervasive]]
+
[[Category:Installation]][[Category:Installing Agency Systems]][[Category:Pervasive]]
Adding Newton by Agency Systems to a workstation requires the installation of Pervasive.  The instructions below reference the most current version of pervasive, however your office may be running an older version.  Since all versions of Pervasive on the same network must match, please contact [http://www.agencysystems.com/support Agency Systems Support] to verify the installed version before proceeding.
 
 
 
== Windows 8 / 7 / Vista ==
 
  
 +
==Full Workstation Install Instructions==
 
*Verify the workstation is running one of the following: Microsoft Windows 8 / Windows 7 / Windows Vista
 
*Verify the workstation is running one of the following: Microsoft Windows 8 / Windows 7 / Windows Vista
  
Line 9: Line 7:
 
   
 
   
 
*You will need to be logged in as a local Administrative user.  
 
*You will need to be logged in as a local Administrative user.  
 
==== Map the Network Drive ====
 
Map a network drive to the share directory containing the empire folder on the Server/Master machine. It is recommended to use the same drive letter on every machine in the office.  For the examples below the letter X: will be used.  Substitute X: with your drive letter as needed.
 
  
;Example:<tt>
+
===Map Network Drive===
:Server Name: SERVERNAME
+
Within '''Both''' command prompt & administrative command prompt
:Shared Folder: APPS
+
Type '''Net Use x: \\servername\APPS'''
:Mapped Path: X:\APPS\ </tt>
+
To confirm each cmd prompt has status '''OK'''
 +
Type '''Net Use'''
  
[[File:Mapnetworkdrive-gui.png]]
+
===Installation of Pervasive===
 +
Run command prompt as Administrator(This step is '''critical''')
 +
Type '''CD X:\empire'''
 +
Type '''PSQL11.3Client32.exe'''
 +
Take all '''defaults''', '''EXCEPT''' you need '''Install as Service''' selected
  
Optionally, the drive can be mapped from a cmd.exe prompt.
+
Open a '''new''' command prompt as Administrator
  net use X: \\SERVERNAME\APPS
+
Type '''PCC'''
 +
#Select '''Tools''' > '''ODBC Administrator or 32bit ODBC Administrator'''
 +
##Not 64bit
 +
#Select the '''System DSN'''  >  '''Add''' (If Agyforms is not already configured)
 +
#Choose '''Pervasive ODBC Client Interface''' and select Finish
 +
#Within the Data Source Name field
 +
  Type '''AGYFORMS'''
 +
#Enter '''Your''' Server Name:
 +
'''"ServerName"'''
 +
#Select '''Get List'''
 +
##Leave everything else '''default'''
 +
#Verify '''Agyforms''' is selected in the drop down box named Database Name
 +
#Select '''Test''' and select '''OK''' once the Connection Successful box appears.
 +
#Select '''OK''' to create the Client DSN.
 +
#'''Exit''' the ODBC Administrator.
  
==== Install the Pervasive Client ====
+
===Setup Agency Systems Icon & Crystal Reports===
Browse to X:\Empire\ and run the pervasive installer PSQ11.3Client32.exe.  The version number of 11.3 may be different if you are using an older version of Pervasive.
+
Run a '''new''' command prompt as Administrator
+
Type '''CD X:\empire'''
If the file does not exist, download it from the following location and save it to the X:\Empire\ folder on the server.
+
Type '''Adduser.exe'''
 +
#If the workstation will have 64bit Microsoft Office installed (Office, Not Windows), replace '''Adduser.exe''' with '''Adduser.exe /64'''
 +
#Select '''Run'''
 +
#Select '''Begin'''
 +
#Select '''Finish'''
  
http://www.asfiles.com/PSQL/PSQL11.3Client32.exe
+
===Testing Agency Systems===
+
#'''Double click''' the Agency Systems icon
Take all of the defaults except, select "Install as Service" when prompted.
+
##Sometimes takes a while to load
+
#Agency: '''95'''
==== Setup Client Data Source Name (DSN) ====
+
#Operator: '''DCS'''
#Select the Microsoft Windows Start Menu.
+
#Password: '''EMPYRE'''
#Enter '''PCC''' in the start search box then select Ok.
+
##Once the application opens, click on one of the tabs to make sure it loads data.
#Select '''Tools -> ODBC Administrator''' or '''32-bit ODBC Administrator''' if using a 64-bit operating system.
 
#Select the '''System DSN''' tab and then select Add.
 
#Highlight '''Pervasive ODBC Client Interface''' and select Finish.
 
#Under Data Source Name enter '''AGYFORMS'''
 
#Enter the full server name in the Server Name/IP: field and select Get List.
 
#Verify AgyForms is selected in the drop down box named Database Name.
 
#Select Test and select Ok once the Connection Successful box appears.
 
#Select Ok to create the Client DSN.
 
#Exit the ODBC Administrator.
 
  
==== Setup the Agency Systems Icon ====
+
==Receive warning upon opening the icon?==
When installing from a mapped network drive, the drive mappings are lost when the Administrator account is elevated.  This is a function of the User Access Control (UAC) in Windows. The elevated and non-elevated administrator accounts have different logon tokens and can therefore have different drive mappings.
+
Click Start  Menu to search
 +
#Type '''internet options'''
 +
#Select '''Security''' Tab
 +
#Select '''Local Intranet'''
 +
#Select '''Sites'''
 +
##Make sure '''all''' boxes are checked
 +
#Select '''Advanced'''
 +
#Type '''S:'''
 +
#Select '''Add'''
 +
#Select '''Close'''
 +
#Select '''OK'''
 +
#Select '''OK'''
 +
#Then you’re ready to use the application!
  
#Select the Microsoft Windows Start Menu.
 
#Enter CMD in the start search box.
 
#Right-click and select Run as Administrator.  '''This step is critical, even if you are already logged into the machine as Administrator.'''
 
#Enter the following commands where X: is the drive letter for your office:
 
net use X: \\SEVERNAME\SHAREDFOLDERNAME
 
X:
 
cd Empire
 
Adduser.exe
 
 
If the workstation will have 64 bit Microsoft Office installed (Office, not Windows), replace Adduser.exe with the following:
 
Adduser.exe /64
 
 
Select Run, Begin, then Finish.
 
 
If prompted to reboot the machine select Yes.
 
  
 
== Potential Error Codes After Installation ==
 
== Potential Error Codes After Installation ==
Line 70: Line 76:
  
 
[[Display Issues Printing Forms or Viewing Window Buttons]]
 
[[Display Issues Printing Forms or Viewing Window Buttons]]
 +
 +
[[Open File Security Warning]]

Revision as of 18:42, 6 October 2014


Full Workstation Install Instructions

  • Verify the workstation is running one of the following: Microsoft Windows 8 / Windows 7 / Windows Vista
  • You will need to be logged in as a local Administrative user.

Map Network Drive

Within Both command prompt & administrative command prompt

Type Net Use x: \\servername\APPS

To confirm each cmd prompt has status OK

Type Net Use

Installation of Pervasive

Run command prompt as Administrator(This step is critical)

Type CD X:\empire
Type PSQL11.3Client32.exe

Take all defaults, EXCEPT you need Install as Service selected

Open a new command prompt as Administrator

Type PCC
  1. Select Tools > ODBC Administrator or 32bit ODBC Administrator
    1. Not 64bit
  2. Select the System DSN > Add (If Agyforms is not already configured)
  3. Choose Pervasive ODBC Client Interface and select Finish
  4. Within the Data Source Name field
Type AGYFORMS
  1. Enter Your Server Name:
"ServerName" 
  1. Select Get List
    1. Leave everything else default
  2. Verify Agyforms is selected in the drop down box named Database Name
  3. Select Test and select OK once the Connection Successful box appears.
  4. Select OK to create the Client DSN.
  5. Exit the ODBC Administrator.

Setup Agency Systems Icon & Crystal Reports

Run a new command prompt as Administrator

Type CD X:\empire
Type Adduser.exe
  1. If the workstation will have 64bit Microsoft Office installed (Office, Not Windows), replace Adduser.exe with Adduser.exe /64
  2. Select Run
  3. Select Begin
  4. Select Finish

Testing Agency Systems

  1. Double click the Agency Systems icon
    1. Sometimes takes a while to load
  2. Agency: 95
  3. Operator: DCS
  4. Password: EMPYRE
    1. Once the application opens, click on one of the tabs to make sure it loads data.

Receive warning upon opening the icon?

Click Start Menu to search

  1. Type internet options
  2. Select Security Tab
  3. Select Local Intranet
  4. Select Sites
    1. Make sure all boxes are checked
  5. Select Advanced
  6. Type S:
  7. Select Add
  8. Select Close
  9. Select OK
  10. Select OK
  11. Then you’re ready to use the application!


Potential Error Codes After Installation

Error: Crpe32.dll not found

Error: 501 Job Failed

Display Issues Printing Forms or Viewing Window Buttons

Open File Security Warning