Receiving the following error after installing FRx SP9:
Connection to FRxSys32.mdb was not successful. Make sure you have permissions to modify files in the FRx SysData folder.
Environment:
GP7.5 in production with SQL 2000
GP2010 in Test with SQL 2008 (fully converted from our production 7.5 on a test system)
FRx 6.7.141 (yes it's still RTM and wasn't my responsibility until recently)
Windows client: XP SP3
SysData folder: Network share with modify permissions
IO_Data folder: Network share with modify permissions
Using FRx 6.7.141, I can connect to both the production (GP7.5) database and the test upgrade (GP2010) database and appears to work. However it only seems to work on GP2010 when logging in as SA. Any other login will not get past the login screen.
I've been told that to connect to GP2010 I will need to have the latest FRx service pack (11). In order to get to SP11 I need to install SP9 first. At the end of the SP9 installation I get the error message referenced above.
After clicking OK the that error message, if I try to open FRx I get the follwing error:
The specification set template file (FRxRpt32.TPL) is missing from the SysData directory. This file is needed to run FRx.
The problem with that is the file does exist in the shared SysData folder and no one else is logged into FRx during the SP installtion.
Since I am new to Great Plains and tasked with performing the upgrades necessary to get us from GP7.5 to GP2010 I would greatly appreciate any help anyone might be able to provide. If you need more information I'll be more than happy to provide it.
Thank you,
Pat B
Connection to FRxSys32.mdb was not successful. Make sure you have permissions to modify files in the FRx SysData folder.
Environment:
GP7.5 in production with SQL 2000
GP2010 in Test with SQL 2008 (fully converted from our production 7.5 on a test system)
FRx 6.7.141 (yes it's still RTM and wasn't my responsibility until recently)
Windows client: XP SP3
SysData folder: Network share with modify permissions
IO_Data folder: Network share with modify permissions
Using FRx 6.7.141, I can connect to both the production (GP7.5) database and the test upgrade (GP2010) database and appears to work. However it only seems to work on GP2010 when logging in as SA. Any other login will not get past the login screen.
I've been told that to connect to GP2010 I will need to have the latest FRx service pack (11). In order to get to SP11 I need to install SP9 first. At the end of the SP9 installation I get the error message referenced above.
After clicking OK the that error message, if I try to open FRx I get the follwing error:
The specification set template file (FRxRpt32.TPL) is missing from the SysData directory. This file is needed to run FRx.
The problem with that is the file does exist in the shared SysData folder and no one else is logged into FRx during the SP installtion.
Since I am new to Great Plains and tasked with performing the upgrades necessary to get us from GP7.5 to GP2010 I would greatly appreciate any help anyone might be able to provide. If you need more information I'll be more than happy to provide it.
Thank you,
Pat B