Stephen, as mentioned by Tom, please try TCP/IP. You can read the KB to find
out how to enable TCP/IP: http://www.yqcomputer.com/
btw, here is a comparison of Named pipe VS TCP/IP:
(SQL.80).aspx. But when we
are connecting to a local SQL server, we are using shared memory by default
which is extremely fast. Therefore, TCP/IP is recommended in general.
Tom, if you are using 64-bit OS and a 32-bit Office, please use
"c:\windows\syswow64\odbcad32.exe" to configure your DSN. But if you are
using 64-bit Office 2010 Beta, you can simply use
WDAC Team, Microsoft.