When I first set up the new server, I had run through those steps to get the linked servers working. I agree that it has to be something in the...

32 Bit OS

Quad core processor

8GB RAM with AWE enabled

The Sql server 2000 was running on MS Server 2000, and now SQL Server 2008 is running on MS Enterprise Server 2008.

Here is the error message:

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "INY10014" reported an error. The provider did not give any information about the error.

Cannot initialize the data source...