web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Frx connection

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

In my company we need create new financial reports, more explicit with a better presentation and for this reason we think use Frx for GP 10 (SP4).

Downloaded a trial version for make a test with excelent results. Now we need step forward with a real database and here come our problem.

When i try to connect with Fabrikam this appears:

"FRx32.OFSIMain.CheckOFSIConnection
-2147221401: Error getting Dynamics version number from table Dynamics..DB_Upgrade"

Is good mean i use a new machine, outside from my network, for security, install GP 10 SP4, Sql 2008 SP1 and upgrade FRx to 6.7.1043.

I did odbc connection in "System DNS", pass the test and apparently everithing is fine.

I read maybe is a permission problems with my user but im using "sa" for connect. Really dont understand.

any idea what could be happening?

Thank you for your time...

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    FRx is having trouble connecting to SQL. Try using a different SQL Client for your DSN.

  • michelle brayton Profile Picture
    95 on at

    You need to ensure that your ODBC name is the same as everyone elses that uses FRx.  Odd but true.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

    Michelle is correct. You are probalby using a shared SYSDATA directory and when you set up your company (Company->Information->System Specific Information) you set your Data Source Name,Great Plains System and Company Database. The data source name(DSN) must be the same on all computers and point to the same server.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans