I reference a file sqldmo.rll in my VB project to get all available MS SQL Server on the network. This work OK on my machine.

When using Package and Deployment wizard, this file sqldmo.rll is included as well. However, the program fails whenever it try to call a method of this sqldmo.rll file.

Do I have to include any other files when distributing the program so that SQL-DMO will work properly?

Thanks.