NOTE! There are many messages that can appear when the software fails to connect to the database. The message you received may not be indicated in this article. Nevertheless, if the software fails to open, this article offers you the best shot at resolving the issue.
When launching Gradience the twin messages below may be encountered.
You do not need to do anything with the Sysdba Password. That message is just a secondary popup that is essentially communicating the fact that the software is unable to connect to the data. Rather than trying to enter a password, please review the 12 known causes of a loss of connectivity between the software and the data that are shown further down in this article, each with it's own solution.
Alternately, you may see something very similar to this...
Other messages may also appear indicating that the software is unable to connect to the database.
Important Support Information
If Gradience won't open after using this, go to www.gradiencesupport.com and click Submit a Request.
If your software license was purchased over 30 days ago, phone support will only be free if you have a current 12-month maintenance plan. Otherwise, the cost of a support call will depend on your license.
- If you have a Professional license the cost of a single support call is $80.
- If you have an Enterprise license, the cost of a single support call is $100.
For a 12-month maintenance plan, please call 800-999-9111 or email firstname.lastname@example.org.
Quick Tip #1 If you're remotely connecting to the computer via RDP, LogMeIn, etc.; you will need to change the SERVER= in the hrware.ini to the IP address of the computer hosting the data or to the loopback address of 127.0.0.1 - See step 4 below for more information.
Quick Tip #2 If Gradience opens successfully on another client computer, copy the hrware.ini file from that computer and use it to replace the hrware.ini file on the computer where Gradience fails to open. This file is located at c:\Programdata\Gradience. The Programdata folder may be hidden.
Quick Tip #3 If you got the error after installing the version 12 update after having run an older version, the cause may be that your data may reside on another computer or on your server. If this is true and you have not installed the version 12 update there, the older version of Gradience will be residing on that other computer or server as well.
That means that an older version of Firebird resided on the other computer or server. Version 12 requires Firebird 3.0 but this version of Firebird must reside at the computer or server where the data resise. So what you may have is a situation, where version 12 on the client cannot connect to the data on the server because the version of Firebird at the server is too old. The solution is to install version 12 on the server as well so as to upgrade Firebird [there] to Firebird 3.0.
List of Causes:
Any one or any combination of these causes may be in play.
Cause #1. The IP Address of the computer hosting the data is Dynamic. The IP must be static.
Cause #2. The shortcut is set to run in compatibility with another operating system. ...Not good.
Cause #3. Running Gradience on Citrix or Terminal Services. Gradience is not supported on these.
Cause #4. Unsupported Operating System. Only supported on Win 7, 8,10, Server 2008, & 2012.
Cause #5. Software is not pointed properly. Never use UNC and never map a drive from the client.
Cause #6. Inadequate permissions to data/ini. The User and System must have Full Control.
Cause #7. Missing line from bottom of the Services file at C:\Windows\System32\drivers\etc.
Cause #8. TimeStation is lacking a local instance of Firebird. This component uses local Firebird.
Cause #9. There is no Gradience folder in the Programdata folder. The software is blind.
Cause #10. Firebird is not started or you have the wrong version. Gradience 12 requires version 3.0.
Cause #11. Port 3050 is unavailable on the host machine. Necessary even if the firewall is disabled.
Cause #12. Remote Access. Re-point the client ini file to the server's IP Address.
Cause #13. Old Version/New Operating System. Pre-version 12 on Win 8, 10, or on Server 2008/2012
Cause 1. IP Address of the computer hosting the data (server) is Dynamic.
You must assign a static IP address to the computer that hosts the data.
Cause 2. The shortcut is set to run in compatibility with another operating system.
Go to C:\Program Files (x86)\Gradience\Professional. Scroll to GCore.exe and right-click on it. Click Properties > Compatibility. Uncheck Run this program in Compatibility mode for...
Cause 3. You’re attempting to run the software on Citrix or Terminal Services.
Move Gradience and the Data of Citrix or Terminal Services. Gradience Software is not supported when deployed on Citrix or Terminal Services. You may use either of the links below to access a PDF that may help.
Running Gradience Pro / Ent in Citrix (not supported)
Running Gradience Pro / Ent in Terminal Services (not supported)
Cause 4. Unsupported Operating System.
Gradience is only supported on Win 7, 8,10, Server 2008, & 2012 so you will have to move the software to one of these operating systems.
Click here to move to a New Server and Re-point the Client Workstations.
Click here to move Gradience Pro & Data from One Standalone to Another.
Click here to install Gradience on a new client workstation.
Cause 5. Software is not pointed properly. Incorrect server name/IP address/database path.
1. Go to C:\ProgramData. The ProgramData folder may be hidden. If so, you can go online to see how to unhide it for your operating system.
2. After opening the ProgramData folder, open the Gradience folder and then open the hrware.ini file.
3. Under [HRWARE] look at PATH=. The drive letter must be a physical drive, not a mapped drive. It must be the [actual] drive as seen from the host machine. Eliminate any double back slashes.
4. Next, look at SERVER=. The server name or IP address must be correct and eliminate any double back slashes from this line as well.
Cause 6. Permissions to the folder containing the database are Inadequate.
The end user needs to either have [ local admin rights on his/her computer only ] or at a minimum, the user needs to have full rights to the folder containing the database file and full rights to the [ local ] Hrware.ini file on his/her computer.
To give the end-user rights to the data, go to the computer/server where the database file resides. Right-click the folder containing the database file. Typically, this folder is named Data. Choose Properties. When the Properties popup opens, click the Security tab and verify that the User and System have Full Control.
To give the end-user rights to the local Hrware.ini file go to his/her own computer and navigate to c:\Programdata (generally this folder is hidden). If so, you can go online to see how to unhide it for your operating system. After opening the ProgramData folder,
Open the Gradience folder and then right-click the Hrware.ini file. Choose Properties. When the Properties popup opens, click the Security tab and verify that the User and System have Full Control.
Cause 7. Missing line from bottom of the Services file at C:\Windows\System32\drivers\etc.
Right-click the Gradience shortcut on the desktop and select Run As Administrator (you should only need to do this once).
1. Go to C:\Windows\System32\drivers\etc.
2. Right click on the Services file and open it with NotePad.
3. Scroll down to the bottom of the file and enter gds_db in the first column and enter 3050/tcp in the second column and enter # InterBase Server in the third column. As an example, please see line second from bottom below.
Cause 8. TimeStation is lacking a local instance of Firebird.
TimeStation is unique in that unlike TimeClock or Attendance or FMLA Tracker, it does not use the instance of Firebird that runs on the server. It uses a local instance of Firebird.
Please go into Services to verify whether you have Firebird Server and Firebird Guardian and that they are both started. One will be shown to be automatic while the other will be shown to be manual but [ both ] must be started.
If they are not, please start one and the other will automatically start. If you do not even have an instance of Firebird on the local machine where TimeStation is running, please uninstall Gradience and then reinstall as a client This will cause Firebird 3.0 to install. Alternatively, you may go online to search for a free downloadable Firebird 3.0. If you manually download and install Firebird, please accept the defaults during installation.
By the way, please also follow the steps for cause #4 in these instructions to ensure that Port 3050 is open on the local machine for the new, local instance of Firebird.
Cause 9. There is no Gradience folder at C:\ProgramData.
OPTION ONE: Gradience opens at the server but not at a client.
1. At the server, go to C:\Programdata\Gradience.
The ProgramData folder may be hidden. If so, you can go online to see how to unhide it for your operating system.
2. Copy the hrware.ini file and save it to a neutral location where you can access it later.
3. At the client with the issue, go to C:\Programdata and create a folder named Gradience.
4. Get the copied hrware.ini from the neutral location and paste it into the new Gradience folder.
5. Open hrware.ini and change SERVER= from Localhost to the name or IP address [of the server].
CAUTION! Do not use a mapped drive and do not use UNC (\\). If you do, Gradience will not open.
Open NotePad to create your hrware.ini file. All you need are three lines.
Enter a drive letter and path following PATH=. On a standalone, the default path is ...
Your path will be different if your database file is located elsewhere on the standalone computer. Paste this file on the client at C:\Programdata\Gradience.
Cause 10. Firebird service is not started or you have the wrong version.
First see whether it is started.
Open Services. Look for Firebird. Depending on the version of Firebird, you may only see one line or you may see two lines. If you see two lines, one will be Firebird Guardian and the other will be Firebird Server. One will be automatic while the other will be manual. Both however, must be running.
- If you see only one instance of Firebird, click on it. If you see Start above and to the left, it means it is [not] started. In that case, click Start.
- If you see two instances of Firebird, click on either one. If you see Start above and to the left, it means that [neither one] is started. In that case, click Start for just the one you clicked on and the other one will start automatically.
Version: Gradience uses the instance of Firebird that resided at the computer or server where the data reside but TimeStation uses a [local] instance of Firebird but the version of Firebird for Gradience version 12 must be Firebird 3.0.
Cause 11. Port 3050 is not configured where the database resides.
Note: This port must be configured on the host machine [ computer where the database resides ] even if the firewall is turned off. Below are the steps you must follow at the computer where the database resides. This may be an actual server or another workstation.
1. Open your Control Panel and then open your Windows Firewall and click Advanced Settings.
2. Click Inbound Rules in the upper left and then click New Rule in the upper right and a popup window will open called [Rule Type].
3. In the center, select Port and then click Next. Another popup window will open called [Protocol and Ports].
4. Select TCP and Selected local ports. In the field next to [Selected local ports], enter 3050 and click Next. A new popup window will open called [Action].
5. Select Allow the connection and click Next. A popup window will open called [Profile].
6. You must select Domain. You [may] select Private and/or Public if you wish and then click Next. A popup window will open called [Name].
7. In the field under [Name] enter Firebird.
8. In the field under [Description] enter "Firebird is the Gradience database engine. It uses Port 3050 on the host machine." Click Finish.
9. Click Outbound Rules in the upper left and in the upper left and then click New Rule in the upper right and repeat steps 3 through 8 above.
Note: Click here for more in-depth Firewall instructions or visit http://goo.gl/JD0AZw
CAUTION! You may have a policy on the server that is overriding the domain policy and allowing partial filtering in the Windows firewall that is blocking port 3050 on the server. There’s more than one place where the firewall can be set. Please check all of these places to be sure that nothing is blocking Port 3050. If you are not an IT professional, ask your IT person to help with this. This is beyond the scope of our support.
Cause 12. Remote Access: The remote tool can’t resolve the server designation in the ini file.
You must alter the server designation on the hrware.ini file.
- If remoting to the server or standalone computer, change the designation Localhost to it’s own IP address or the loopback address of 127.0.0.1
- If remoting to a client computer; change the name of the server to the server’s IP address.
Go to C:\ProgramData. The ProgramData folder may be hidden. If so, you can go online to see how to unhide it for your operating system. After opening the ProgramData folder, open the Gradience folder and then open the hrware.ini file.
Look at SERVER= following [HRWARE].
If remoting to the server or standalone computer (RDP, etc.), change the designation from Localhost to it’s own IP address or the loopback address of 127.0.0.1 and click Save > Close and try to open the software.
If remoting to a client computer (RDP, etc.) change the name of the server to the server’s IP address.
Don’t worry about any other lines other than the two lines that directly follow [HRWARE]
Additional Details on this Matter:
…At the Server or Standalone: (computer where the software and the database reside)
PATH= This drive letter and this path must be identical on the server and the clients.
SERVER= Server Name is OK unless you are remoting-in. In that case, change this to the server’s IP Address.
…At a Client: (computer where only the software resides)
PATH= This drive letter and this path must be identical on the server and the clients.
SERVER= Server Name is OK unless launching remotely. In that case, change this to the server’s IP Address.
Note: Do not concern yourself with RUN PATH or any other portions of the hrware.ini file.
Cause 13. Old Gradience Version on Win 8, 10, or on Server 2008/2012
Gradience versions older than 12 were never tested on Windows 8. Windows 8.1, Windows 10, or on Servers 2008 or 2012 but they have been found to work.
The problem people generally encounter is not software functionality but installation. It is common on the operating systems listed above to fail to create a Gradience folder at C:\ProgramData so there is no place for the hrware.ini file to reside.
This ini file points the software to the database. Without this file the program has no idea where the database is located so it cannot connect to the database when you try to open the program.
Once you create a Gradience folder at C:\ProgramData, and then install the program, this all-important hrware.ini file will be created. The program will then be able to connect to the database.
You do not have to uninstall anything. Simply create the Gradience folder at C:\Programdata and then reinstall. If you do not see a ProgramData folder at C:\ it is because it is being hidden. You may go online to see how to unhide hidden folders/items for your particular operating system.
CAUTION! Versions older than 11 or 12 are not supported.
Still Won't Open?
Note: Please see our advanced troubleshooting document if none of the solutions above helped you to resolve this issue.