Solved

Microsoft FRX to Dynamics connection issues

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

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…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…

734 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