I'm just a simple techie who sometimes forgets things.
I use this as a notepad to remember things by.
I hope it helps you too.
I post as myself, not as any organisation.
Sunday, 19 September 2004
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.