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:
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?
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"
- Proposed as answer by Crakdkorn Thursday, August 12, 2010 12:00 AM
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.
- Proposed as answer by Vindy-MSFT Saturday, August 21, 2010 4:52 PM