Microsoft OLE DB Provider for ODBC Drivers (0x80004005)?

I got a local version of SQL2000 and I can connect using Dreamweaver and I
can see data when testing the recordset but when I view the page, I get the
standard error

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not
found.
/orderhistory.asp, line 19

Any clue what is causing this error and how to solve it?

I know the 80004005 error is the "I can't find the database" error but I
wonder, since I can see the data in dreamweaver, why it's not appearing when
the page is view.

Thanks for the help.