Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Server field blank at login

(0) ShareShare
ReportReport
Posted on by 60

One user only, when he brings up the login screen, the server field and dropdown are blank.  All other users have the server in place with no issue.  How do I re-establish the path for this user on his login screen?

*This post is locked for comments

  • jamies Profile Picture
    jamies 15 on at
    RE: Server field blank at login

    I have chanced upon the same issue as the above and needed to download the SQL native client driver.  Are you able to point where to download for SQL Server 2014 and possibly including instructions? Thanks and appreciate your help.

  • Verified answer
    KKTT Profile Picture
    KKTT 60 on at
    Re: Server field blank at login

    Thanks for your replies.  This user had been using GP just fine until today.  The reply regarding the ODBC connection led me to the answer.  The ODBC connection was there but it couldn't connect because it couldn't find the SQL native client driver.  I downloaded and installed just the driver and now it works.  Odd how it lost this, but at least it works now.  Thanks again.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Server field blank at login

    Hi Aaron,

    It's all good.  :-)  Independent confirmation of an answer can't hurt.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Server field blank at login

    Sorry Victoria,

    We must have been posting at the same time.  

    Aaron

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Server field blank at login

    It sounds like this user doesn't have an ODBC connection setup to connect to the GP data.  Go to Administrative tools and verify that there is a connection setup in the System DSN tab.  This will allow all users to access the gp data from that particular machine .

    There is a KB article that shows how to do this:

    mbs.microsoft.com/.../mdgp_howto_setup_odbc.htm

    Download the word document and it should walk you through the process.

    Regards,

    Aaron

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Server field blank at login

    Is this on a 64-bit OS on a workstation (as opposed to a terminal server where multiple users are logging in)?  If so, you must create a 32-bit ODBC for GP.  mbs.microsoft.com/.../mdgp_howto_setup_odbc.htm    

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans