ISSUE:

Unable to access Pastel Software with Error Message Status 116 showing.

CAUSE:

The error 116 is a network communication problem between a workstation and the server. These communication problems could be due to network hardware, cabling or the network user rights and pervasive settings. This error is thrown by pervasive because it cannot establish a connection to the server.

SOLUTION:

OPTION 1 - Engine and Loc file

1. First check that the Pervasive Pre-load icon is running in the bottom right hand corner of your screen (in your systray).
2. Log everyone out of Pastel.
3. Locate your company data folder and delete any `pvsw.loc files that may be within there.
4. Then log everyone back in and see whether the error occurs.
5. You will then need to assign the Gateway thereafter (please view option 3 below).

OPTION 2 - Pervasive Licence - Check if Pervasive License is Correct

1. Go to Start...Programs...Pervasive SQL ...Other Utilities...Licence Administrator
2. At the very bottom, please check to see whether there is a Permanent licence applied for Pervasive. If there are no Permanent Licenses, you will need to re-register your Pastel Program. Please contact our support staff at registrations@sagepastelsoftware.com.au to obtain a temporary pervasive license in order to get into Pastel for registration. Otherwise, move to option 3.

OPTION 3 - Assigning a Gateway

1. Log everyone out of Pastel.
2. Locate your company data file.
3. Delete any 'pvsw.loc' file that may be within your data file. We can then assign a Gateway.
4. To assign a Gateway, (PLEASE NOTE: THIS PROCEDURE MUST BE DONE IN THE SERVER AND THEN IN ALL WORKSTATIONS)
   
1. In Windows click on Start.....Programs.....Pervasive.SQL .... Other Utilities... Gateway Locator
2. click on Change button
3. select "Assign a Gateway"option and type/browse your server name and click ok
4. The UNC field will now be filled with a path for your server, something like this "\\YOUR_SERVER_NAME\C$\PVSW\Bin\~PVSW~.LOC"
5. Click in exit
   
5. Then log everyone back in and check to see if the error occurs again?

OPTION 4 - Pervasive Settings
       If the error continues to occur, then please run through the following Pervasive settings that need to be set on all PC's including the server:

1. In Windows click on Start.....Programs.....Pervasive.SQL ....Control Center
2. On the right panel double click on the 'Pervasive.SQL Engines' icon
3. Double click on the resulting computer name icon
4. Double click on the 'Configurations' icon
5. Double click on the 'Client' icon
6. Double click on the 'Communications Protocols' Folder
7. Double click on the 'Enable auto Reconnect' option and set it to 'ON'
8. Double click on the 'Supported Protocols' option and ensure that 'Microsoft TCP/IP' is the only selected protocol in the right panel.
9. On the left panel click on the 'Performance Tuning' folder
10. On the right panel click on the 'Use cache Engine' option and set it to 'OFF'
11. On the left panel click on the 'Configurations' icon
12. This time double click on the 'Server' icon
13. Double click on the 'Communications Protocols' Folder
14. Double click on the 'Enable auto Reconnect' option and set it to 'ON'
15. Double click on the 'Supported Protocols' option and ensure that 'Microsoft TCP/IP' is the only selected protocol in the right panel.
16. On the left hand panel click on the 'Memory Usage' folder
17. Double click on the 'System Cache' option and set it to off.
    Note: The above steps need to be performed on all PC's on the network (including the server) which runs Pervasive.