Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

FRx Report Designer Error

Posted on 2010-09-23
4
Medium Priority
?
1,142 Views
Last Modified: 2013-12-11
Environment:
Microsoft FRx Release 6.7.9111
Microsoft Windows Server 2003 R2
Logged in as Domain Admin
System DSN created.

Process:
Open FRx Report Designer
Login
Click Row Formats
Click New
Click EDIT -> Add Rows from Chart of Accounts...
Click OK on Window (Error occurs here)

Conditions:
When I log into FRx as sa the above works without an error.
When I log in as another user, I receive the error: "Error opening connection to"

The user (non SA login) can run reports through FRX without a problem.

Any input would be appreciated. Error when NOT sa.
0
Comment
Question by:mirey
[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
4 Comments
 
LVL 10

Expert Comment

by:Jeff Wight
ID: 33798867
If you log into GP with the user account that gets this error, can you access Account data (Cards -> Financial -> Accounts)?



0
 

Author Comment

by:mirey
ID: 33799616
jd_wright,
I logged into GP with this user and was able to pull up CARDS->FINANCIAL->ACCOUNTS and when I click on the lookup for the account field in the account maintenance window, I get a window with all the GL accounts.
0
 

Accepted Solution

by:
mirey earned 0 total points
ID: 34394326
We solved this issue with a quick fix, applied the latest service pack for FRx and all was good.
0
 

Author Closing Comment

by:mirey
ID: 34424465
We solved this issue with a quick fix, applied the latest service pack for FRx and all was good.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

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…
Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

636 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