Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Microsoft FRX to Dynamics connection issues

Posted on 2009-05-12
5
Medium Priority
?
1,207 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

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

Author Comment

by:kandreassen
ID: 24368398
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 2000 total points
ID: 24368409
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
ID: 24368501
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
ID: 24372853
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

715 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