XP SP2 SQL ODBC Problem

I couldn't get my XP SP2 box to connect to an MSDE instance after applying SP2 despite the System DSNs being setup and tested correctly before the installation of XP SP2.  Found that I had to go into the DSN and click "uses dynamic port" under client options and then change it back to a fixed TCP 1433 port.