Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / 'Error 8900 - A Di...
Microsoft Dynamics GP (Archived)

'Error 8900 - A DirectLink error has occurred attempting to connect to the DB for this company' in FRx

(0) ShareShare
ReportReport
Posted on by Ben Faris 910

We receive this error in FRx when we try to run the 'Build Local GL Index' utility on the Forecaster company within FRx.  The reason we are trying to run this utility is because we are noticing discrepancies in our Reporting Tree that pulls in the budget data from Forecaster. 

It will be helpful to know that we recently migrated our Great Plains system to new hardware (database and application servers).  So originally we thought it was was a simple ODBC disconnect, but we verified the ODBC connection back to the server that Forecaster is still running on tests successfully.  So when we go into Company > Information in the FRx application, everything saves correctly for the Forecaster company.  We only get this error when we try to rebuild the GL indexes. 

Our Forecaster environment has not been touched, so the DirectLink settings are still the same as before when they were working fine.  We are on the latest FRx service pack as well. 

Can FRx even point to a separate server to retrieve the Forecaster database or does it need to be local with the Great Plains databases as well? 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 'Error 8900 - A DirectLink error has occurred attempting to connect to the DB for this company' in FRx

    Glad to hear you got it resolved!

  • Ben Faris Profile Picture
    Ben Faris 910 on at
    RE: 'Error 8900 - A DirectLink error has occurred attempting to connect to the DB for this company' in FRx

    That was the fix, Jake.  Thanks a bunch!  I just had to copy the .dll over from the old server...it had not been transferred.  

  • Ben Faris Profile Picture
    Ben Faris 910 on at
    RE: 'Error 8900 - A DirectLink error has occurred attempting to connect to the DB for this company' in FRx

    Thanks, Jake.  Good suggestion on the fsforecaster.dll.  I'll look into that.  Do you know if the .dll will register on a 64-bit machine if the .dll from the old system was on a 32-bit machine?  

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 'Error 8900 - A DirectLink error has occurred attempting to connect to the DB for this company' in FRx

    I recommend making sure you are using the latest version of FRx which is SP12. If you are on that, verify that the fsforecaster.dll file is in the FRx code folder.

  • Ben Faris Profile Picture
    Ben Faris 910 on at
    RE: 'Error 8900 - A DirectLink error has occurred attempting to connect to the DB for this company' in FRx

    Babu, we do not have Analytical Accounting installed with GP, nor is it a default company in FRx.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: 'Error 8900 - A DirectLink error has occurred attempting to connect to the DB for this company' in FRx

    Hi this will happen when you have analytical accounting company as default company in Frx.  Please refer the following link to resolve this issue.

    support.microsoft.com/.../en-us

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans