Great questions: Here's the background:

Server 1 has SQL2005 and Visual Studio 2005 and does not contain any working data.

Server 2 has SQL2K and Enterprise Manager and contains...

I am having the same issue and I did try using the OLEDB for SQL Server but ended with the same error:

"The selected connection manager uses an earlier version of...