SQL-DMO Install on SQL Server 2005 Express Client

Question

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is:

SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML

I get a message something like 'SQL Server 2005 Version does not support this install option.'

How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

Answer 1

DMO does not ship with Express. But you can obtain at http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en.

Look for "Microsoft SQL Server 2005 Backward Compatibility Components"

Thanks,

Peter

Answer 2

I've installed the BC Components but now I'm confused. I can't find a sqldmo9.dll so i assume it updated sqldmo.dll -- except it didn't. It's still version 8. What did i do wrong?

Answer 3

Just a note, I installed the DMO on a sql 2008 server.  The point being to allow a COM application have a means to access an nvarchar(max) datatype.  Since it is a COM object, it didn't matter to me whether it installed to 2008 or 2005, just that the sqldmo.dll was available for COM.  It successfully performed a late binding to asp classic and to a vb6 reference (from program files - microsoft sql server tool binn).

This is exactly what was needed.  Thanks for the link Peter.  I am proposing your solution as the answer.