Gradience Pro / Enterprise - Dynamic SQL Error 901

Dynamic SQL Error - SQL error code = 901 - Feature not supported.

You may follow the steps below or you may print-out the one-page PDF below.

There are two approaches to resolving this issue. If plan a fails to resolve the issue, move on to plan B.

Plan A:

1. On the client workstation, go to C:\Programdata\Gradience and remove the hrware.ini file. 

2. Uninstall and then reinstall the software. During reinstall, select Standalone.

3. Launch to verify the software connects to the new, blank, local database. No product key needed, continue in demo mode.

4. Close the program and go back to go to C:\Programdata\Gradience and open the hrware.ini file and change the 2nd and 4th (PATH= & SERVER=) to point it back to the database that is on the server.

CAUTION! Do [not] map a drive to the database on the server and do [not] use UNC (\\) in the PATH line or the SERVER line. Our software uses TCP/IP to connect so using a mapped drive or UNC will [not] work.

5. Launch the program once again and it should connect without error. If the error persists, move on to Plan B below.

Plan B:

1.  Uninstall Gradience.

2.  Uninstall FireBird.

3.  Rename the HRWARE.INI file at c:\Programdata\Gradience.

5.  Open the Registry Editor. Click Start and type regedit in the address bar and press your Enter key. 

6.  When the editor opens, click File > Export. The Export Registry File popup will open.

7.  Enter a file name at the bottom and click Save. This will back up your registry as a precaution.

8.  Navigate to HKEY_CURRENT_USER\SOFTWARE and delete the Gradience folder.

9.  Then go to HKEY_LOCAL_MACHINE\SOFTWARE and delete the Gradience folder.

10. Reinstall the software as a Standalone. We realize this will point it locally.

11. Open the software and then close the software.

12. Go to C:\Programdata\Gradience and open the hrware.ini file and change the 2nd and 4th (PATH= & SERVER=) to point it back to the database that is on the server.

CAUTION! Do [not] map a drive to the database on the server and do [not] use UNC (\\) in the PATH line or the SERVER line. Our software uses TCP/IP to connect so using a mapped drive or UNC will [not] work.

 

 

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.