RMO on Windows 7 - The Specified module could not be found
- by AGoodDisplayName
My machine:
Windows XP (x86), VS2008, .net 3.5, sql server 2005, WinForms - App works fine.
Production Machines: Windows 7 (x64), SQl Server 2005 Express - App Starts but throws exception
Visual Studio Targeting x86 on setup project and RMO project. Visual Studio gives me a a couple warnings but I can still build:
Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='10.0.0.0') of assembly 'Microsoft.SqlServer.Smo.dll'
Unable to find dependency 'MICROSOFT.SQLSERVER.MANAGEMENT.SQLPARSER' (Signature='89845DCD8080CC91' Version='10.0.0.0') of assembly 'Microsoft.SqlServer.Management.SmoMetadataProvider.dll'
This is a simple RMO (Replication Management Objects) app that initiates a pull subscription in SQL Server 2005 and displays status. Works fine on my machine, but fails on the production machine. I'm using a setup project to install the app on the production machine, but I think I'm missing a dependency somewhere, but I can't figure it out.
On the production machine the app starts fine, but when I try to synch the subscription i get:
System.IO.FileNotFoundException: The Specified module could not be found. (Exception from HResult: 0x8007007E)