Interop Question

[AndyLee100]

I recently created an application that needed a reference to SQLDMO.

This then created in the Solution Explorer a reference to SQLDMO and also in the working folder a file called Interop.SQLDMO.dll.

Everything was fine until I went to run the program standalone as an application. It gave an error that it could not find the SQLDMO.dll file. To overcome this I copied the Interop.SQLDMO.dll file into the same path as the application and everything is now fine and dandy.

The question is do I need to do this or should I be approaching it another way? Is there an option in the IDE that I have missed or a bit of code that I need to add to the application?

With a VB 6 application, all you needed to do was add the reference and more often than not the dll was sitting in the System32 folder and the application would run.

Any help appreciated

Thanks

Andy Lee

 

[JohnYingling]

Well, in VB6, they had to be registered as COM Dlls, leading to "DLL Hell". Rejoice that you are now free. You missed nothing except maybe creating your own Install. But if you can get away with a simple XCopy of a directory why bother.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)

 

[chiph]

John is right -- more than likely there is a way to do what you're trying to do via the .NET framework. I would spend some time looking at the XmlDataDocument class, to start with.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[AndyLee100]

Chip,

As far as I am aware SQLDMO is not as yet part of the .net framework but an integral part of SQL Server.

I think it is probably part of Visual Studio 2005.

I am working with .Net 2003 and SQL 2000.

Thanks for the reply though.

Andy