Attaching to a SQL Server 2000 database from MSDE

[sedrisco]

I have SQL Server 2000, while other people only have MSDE. We are trying to detach a db from 2000 and attach it (using OSQL) on another computer that only has MSDE. We're getting an error that says the header information is not recognized, which seems to indicate a version problem - is MSDE not compatible with 2000? Or is there another method for detaching and attaching when MSDE is involved? Or is there a backward compatibility issue with SQL Server 2000 and 7.0? Any ideas or suggestions would be much appreciated.

Thanks.

 

[Hal10K]

You need to have the correct version of MDAC on the MSDE (version 1.0) computers to use or even see SQL2K from a prior version. The easiest fix is probably to put the SQL2K client connectivity on those machines as a minimum, or going up, MSDE 2.0, and orSQL2K tools (much better than the SQL70 tools).
Alternatively, you could connect to the MSDE from the SQL2K box and use MTS to move the data. Down version from 2K to 7 works, but not to 6.5 (EM changed radically at 7.0).
-hal