Gradience Pro / Enterprise - Runtime Error 217 on a Windows 10 Server after Update 1709

Solution When Using a Windows 10 Computer as a Server

If you host the data on a Windows 10 computer, but share the data with Gradience that is installed on other computers, the computer that is hosting the data is considered to be your server. You must be sure whether the affected computer is…

  • A Client or...
  • A Standalone, or…
  • A Server,

How to Verify whether this machine is a Server or a Client or a Standalone...

1. Go to C:\ProgramData\Gradience and open the Hrware.ini file. 

2. Very near the top, you will see a line that begins with...

Server= ...Whatever follows the equal sign is the computer hosting the data.

If you see anything other than the word Localhost, it means that your machine is a Client Workstation. If you discover that your computer is actually a Client Workstation instead of a Standalone Computer or the Server, please click here to access the correct instructions.

If you see the word Localhost following the equal sign means that this machine is hosting the data in which case you have ruled out a Client Workstation but you could be a Standalone or a Server because [both] host the data. The difference is a Standalone is the [only] computer [using] the software while a Server is sharing the data with Gradience installed on [other] computers.

If you know of anyone else who can access the same data as you by using Gradience on his/her computer, then that other person is using Gradience on his/her computer as a Client workstation, and you are running Gradience on your computer as a Server. In this case, follow the steps below.

Version 12 Users Have two Options...

Option One for version 12 Users:

If you had previously used version 11 and upgraded to version 12 but have been running version 12 for only a short while or you have not done much data entry since using version 12, you may want to consider reverting back to version 11. If you do this, you will have to restore a backup that you made while you were using version 11 so any data entered while using version 12 will have to be re-entered but at least you can continue using Gradience on Windows 10.

Option Two for version 12 Users:

If you have been running version 12 for many months or have never run anything other than version 12, It will not be possible to revert to version 11 because you will have no version 11 backup that you can restore. For this situation, we can offer you a workaround below that will allow you to remain on version 12.

Workaround for Option Two Above...

First copy your database file. The name of your database file is Hrware.gdb and paste it into a neutral location. If you do not know where to find it, go back to C:\ProgramData\Gradience and open the Hrware.ini file. Very near the top, you will see a line that begins with...

PATH= ...Whatever follows the equal sign is precise location of the data.

Copy the Hrware.gdb and paste it into a neutral location.

Open up a Windows 7 VM [virtual machine] on your Windows 10 computer. Install version 12 on that. You may click here to install version 12 as a Server on the VM. This will create a new, blank database on the VM. It will be named Hrware.gdb and will be located at C:\ProgramData\Gradience. You must replace the new, blank database with the copy you made of your original database file. 

Repointing the Client(s)...

You will now have to repoint Gradience running on the other computer(s) so that the software running there can find the data in the new location on the Windows 7 VM. YOu can accomplish this by following the steps below.

1. At the VM server go to C:\ProgramData\Gradience and copy the Hrware.ini file. 

2. Paste the copied HRware.ini file into a neutral location and then open it there.

Very near the top, you will see a line that begins with...

SERVER= 

The word Localhost means [this same computer].

3. Change the word Localhost to the name of the VM Server, save the change and close the file.

4. from the first client workstation go to where you saved a copy of the altered Hrware.ini file.

5. Copy the altered Hrware.ini file and then go to C:\Program Data\Gradience.

6. Replace the existing Hrware.ini file with the altered one and repeat this at all other clients.

Version 11 Users - There are two Types...

  • Those who had version 11 all along
  • Those reverting back to version 11 from version 12

Those who had version 11 all along...

1. Go into Services and stop Firebird.

2. Go to Programs and Features and uninstall Firebird and Gradience [if you see them].

3. Go to C:\Program Files and delete the firebird folder [if you see one].

4. Go to C:\Program Files (x86) and delete the firebird folder [if you see one].

5. Go to C:\ProgramData and delete the firebird folder [if you see one].

6. Please click here to reinstall Gradience as a Standalone.  

Those reverting back to version 11 from version 12

1. Go to where your database is located (Hrware.gdb) and rename it Hrware_v12.gdb.

If you do not know where to find your database file, go back to C:\ProgramData\Gradience and open the Hrware.ini file. Very near the top, you will see a line that begins with...

PATH= ...Whatever follows the equal sign is precise location of the data.

2. Go into Services and stop Firebird.

3. Go to Programs and Features and uninstall Firebird and Gradience [if you see them].

4. Go to C:\Program Files and delete the firebird folder [if you see one].

5. Go to C:\Program Files (x86) and delete the firebird folder [if you see one].

6. Go to C:\ProgramData and delete the firebird folder [if you see one].

7. Please click here to reinstall Gradience as a Standalone. This will create a new, blank database file named Hrware.gdb in the same folder where you renamed your original database file. 

8. You may now click here to restore your most recent version 11 database file.  

9. Open Gradience and re-enter any data that had been entered while you were using version 12.

If you need further assistance, please go to www.gradiencesupport.com and click on Submit a Request. When you submit your request, please be clear as to the following facts...

1. The full, multi-digit version number for Gradience.

2. The number of computers that are running Gradience.

3. The operating systems of the computers/server running Gradience.

4. The account number [if known] of the organization running the software.

5. The name of & main business phone number of the organization running the software.

6. The sales order number [if known] for the software license purchase. 

7. If the software was purchased through a reseller such as Office Depot, or Staples, or SHRM, or Quill, or Amazon, etc., please send us a scanned copy of the receipt. We are only authorized to render support to those for whom we can verify a current software license.

 

 

 

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.