Solved

Microsoft FRX to Dynamics connection issues

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

736 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