I just had a call with a client whose Dynamics GP Server field was always blank when they launched GP.
The drop down list had entries, and the user could log into GP, but every time they launched GP, they had to re-select the Server value.
I checked the Dex.ini file and saw that it did have a SQLLastDataSource value.
SQLLastDataSource= Dynamics GP 2013
I noticed that there was a space at the between the equal sign and the name, so I removed the space, saved the Dex.ini and relaunched GP, but that didn't resolve the issue.
I then found this KB article, but it discusses a completely blank Server drop down list--not a Server field value that remains blank and doesn't doesn't display a default value.
But based on that article, I decided to double check the ODBC DSN settings. We confirmed that the GP DSN was present in the 32-bit ODBC settings window and was using the proper SQL driver, so I was stumped.
On a whim, I decided to confirm the DSN settings, and that's when I saw the likely culprit.
Did you catch that? See the issue?
Notice that there is a sliver of blue before the word Dynamics?
There was a space in front of the DSN name.
The client had manually created their Dynamics GP DSNs, and in the process had accidentally typed a space at the beginning of the name.
We removed the space from the beginning of the DSN name, relaunched GP, and the Server value defaulted just fine.
Apparently Dynamics GP can't handle a DSN that starts with a space. The DSN will work, but it will never default in the Server field when you launch Dynamics GP.
Whenever I think I've seen all of the GP oddities, a new one pops up right on queue.