Gradience Pro / Enterprise - Dynamic SQL Error on Launch


When attempting to open Gradience...

  • Attendance
  • Records
  • TimeClock
  • TimeStation
  • FMLA Tracker

...the following error appears...

Dynamic SQL Error 
SQL Error Code = -901 
feature is not supported 

Likely Cause: The path to the database in the ini file includes the name of the server.


1. Go to C:\ProgramData\Gradience. If you do not see the ProgramData folder, it is because it is hidden. Go online to find the simple steps to make hidden folders visible for your particular operating system.

2. Open the Hrware.ini file. 

3. The 2nd line of text begins with...


4. Delete the name of the server from this line. The line should begin with the drive letter.

5. Click Save.

Note: The 3rd or 4th line from the top will begin with...


The name of the server or the IP address of the server must follow the equal sign.

Since the name of the server is already established  after SERVER= it is not necessary to have the server name after PATH=.




Have more questions? Submit a request



Article is closed for comments.