Solved

Microsoft FRX to Dynamics connection issues

Posted on 2009-05-12
5
1,202 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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

615 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