Solved

Microsoft FRX to Dynamics connection issues

Posted on 2009-05-12
5
1,189 Views
Last Modified: 2013-12-11
I have Dyanics on a local server within my LAN connecting via ODBC, I have installed MS FRX on a local computer and pointed it to the server i have Dynamics on. When I try to log into the company I created in FRX i get this error message,

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

All of the DB connections seem to be correct and I get this
0
Comment
Question by:kandreassen
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Victoria Yudin
Comment Utility
Does this also happen when you try to log on as 'sa'?
0
 

Author Comment

by:kandreassen
Comment Utility
I tried to logon as the one user I set it up for and as sa, I think this error appeared when I was trying sa.
0
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
Comment Utility
Then I would suspect there is an issue with the company setup.  Can you verify all the databases are spelled correctly and in all caps?
0
 

Author Comment

by:kandreassen
Comment Utility
Yes, I checked that and added another company in the company list, but still have the same problem.
0
 
LVL 18

Expert Comment

by:Victoria Yudin
Comment Utility
Two more things you can check are:

1. Does your ODBC connection specify a default database?  Sometimes FRx has a problem with that, so make sure that box is unchecked.
2. Does the frl_ofsi_data table exist in your DYNAMICS database?

Also, what version and service pack of FRx?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now