Open Forum

FRx Issue - 40002 RDO/DSN error

  • 1.  FRx Issue - 40002 RDO/DSN error

    BRONZE CONTRIBUTOR
    Posted Apr 02, 2020 07:43 PM
    I have a client still running FRx 6.7 SP9 on SL2011 and is running into an issue of not able to log in to the company. They are using Windows Authentication for accessing FRx.

    I have run everything thing I can remember to try to get it to work including the FRx/GL Build query, updating the Master password, etc.

    Does anyone else have any thoughts on what i may be missing.

    Thanks for any help.

    ------------------------------
    David Safstrom
    Senior Consultant
    NexTec Group
    Roswell GA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: FRx Issue - 40002 RDO/DSN error

    GOLD CONTRIBUTOR
    Posted Apr 03, 2020 06:53 AM
    David,
    Thar error usually refers to an ODBC or security error accessing the database.  Does the user have Dynamics SL on the workstation?  If so, have the user log into Dynamics SL and run a report, this creates the user ODBC connection.
    Also, to trouble shoot this you could have another user log into the workstation that can launch FRx to test if it is the user or the local configuration.
    Make sure the ODBC in the FRx company setups point to a valid FRx ODBC connection.

    ------------------------------
    David Callery
    Consultant
    Coe & Company, LLC
    Jefferson LA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: FRx Issue - 40002 RDO/DSN error

    GOLD CONTRIBUTOR
    Posted Apr 03, 2020 09:53 AM
    ​So they have Use Windows authentication checked on the System Specific Information tab of the Company Information screen? If that's the case (and I don't think that option was available until after service pack 9), then FRx requires its own ODBC DSNs that have the With Integrated Windows authentication option chosen (the DSNs created by Dynamics SL use SQL Server authentication).

    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: FRx Issue - 40002 RDO/DSN error

    SILVER CONTRIBUTOR
    Posted Apr 03, 2020 11:00 AM
    I would also make sure the FRx for Dyn SL SQL scripts were run.

    ------------------------------
    Derek Krebs
    Sr Consultant
    MSX Group
    Carlsbad, CA
    Derek.Krebs@msxgroup.com
    ------------------------------

    Academy - Online Interactive Learning from Experts