Error message when you log on to a company in Microsoft FRx: "8900: FRx is unable to establish a connection to the general ledger. Verify that GPConn.dll exists on your computer and that it is registered"

Article ID: 912977 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you sign in to a company in Microsoft FRx, you receive the following error message:
8900: FRx is unable to establish a connection to the general ledger. Verify that GPConn.dll exists on your computer and that it is registered.

CAUSE

This problem occurs for one of the following reasons.

Cause 1

This problem occurs if the GPConn.dll file is not located in the following directory:
C:\Program Files\Common Files\Microsoft Shared\Dexterity
To resolve this problem, see Resolution 1.

Cause 2

This problem occurs if the .dll files are registered incorrectly. To resolve this problem, see Resolution 2.

Cause 3

This problem occurs if the Open Database Connectivity (ODBC) name is incorrect. To resolve this problem, see Resolution 3.

RESOLUTION

Resolution 1

To resolve this problem, copy the GPConn.dll file from a working workstation. To do this, follow these steps:
  1. On a working workstation, right-click Start, and then click Explore.
  2. Expand Local Disk (C:).
  3. Expand Program Files, click Common Files, click Microsoft Shared, and then click Dexterity.
  4. Right-click the GPConn.dll file, and then click Copy.
  5. Paste the GPConn.dll file in a shared folder on the network.
  6. Locate the GPConn.dll file that you copied to the network share.
  7. Right-click the file, and then click Copy.
  8. On the workstation on which you receive the error message, right-click Start, and then click Explore.
  9. Expand Local Disk (C:).
  10. Expand Program Files, click Common Files, click Microsoft Shared, and then click Dexterity.
  11. Right-click the Dexterity folder, and then click Paste.
  12. Right-click the GPConn.dll file, and then click Open With.
  13. Click Browse.
  14. Expand Local Disk (C:).
  15. Expand Windows, and then click System 32.
  16. Locate the RegSvr32.exe file in the System 32 folder.
  17. Click Open, and then click OK.
  18. Click OK in the message that states that the file was registered successfully.

Resolution 2

Manually register any files that are not registered successfully. To do this, follow these steps for each file that is not registered successfully:
  1. Locate the file by using Windows Explorer.

    Note If you cannot locate the file, you can copy the file from a working Microsoft FRx workstation.
  2. Right-click the file, and then click Open With.
  3. In the Open With dialog box, click Browse, and then locate the System32 folder.

    Note For Windows Vista and for Windows XP, the default location of this folder is C:\Windows\System32. For Windows Server 2003, the default location of this folder is C:\WinNT\System32.
  4. In the System32 folder, click the RegSvr32.exe file.
  5. Click OK to close all the dialog boxes. You should receive a message that states that the file was registered successfully.

Resolution 3

To resolve this problem, verify that the ODBC name is correct. To do this, follow these steps:
  1. In Microsoft FRx, click Company, and then click Information.
  2. Click the company in which this problem occurs, and then click the System Specific Information tab.
  3. In Data Source Name, note the ODBC name.

    If the ODBC name is incorrect, click the Data Source Name arrow, click the ODBC for Microsoft Dynamics GP in the list, and then click OK.

    If the ODBC for Microsoft Dynamics GP does not appear in the list, you must create a new ODBC. If you have not set up your ODBC data source, click Define to access the ODBC Data Source Administrator, or contact your database administrator to set up an ODBC connection. The ODBC must be set up as a System DSN.
  4. In the Great Plains System Database box, type DYNAMICS in uppercase letters. DYNAMICS is the name of the Microsoft Dynamics GP system database.
  5. In the Company Database box, type the name of the Microsoft Dynamics GP company database.

    Note To find the Microsoft Dynamics GP company database name, open Microsoft Dynamics GP, click Tools, point to Setup, point to Company, and then click Company. The Company ID is the company database name.

    For more information about how to create an ODBC, click the following article numbers to view the articles in the Microsoft Knowledge Base:
    300596 How to create a system Data Source Name (DSN) in Windows 2000
    305599 How to create a system Data Source Name in Windows XP

Properties

Article ID: 912977 - Last Review: July 28, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0, when used with:
    • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
Keywords: 
kbtshoot kbgreatplainsfrx kberrmsg kbmbsmigrate kbprb KB912977

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com