So I finally just figured out what was going on and thought I would share with the rest of you. On my SQL 2008 installation, the TCP/IP and Naming Pipes protocols aren't enabled by default, which would cause the issues I was having of trying to connect to them via ODBC. I love having to try and pretend to be a DBA.
Question is, besides the obvious security reason... why would the TCP/IP protocol be disabled by default? Really?