Microsoft FRX to Dynamics connection issues

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
kandreassenAsked:
Who is Participating?
 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
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
 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Does this also happen when you try to log on as 'sa'?
0
 
kandreassenAuthor Commented:
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
 
kandreassenAuthor Commented:
Yes, I checked that and added another company in the company list, but still have the same problem.
0
 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.