Hi guyz
After I loaded a new reference to my project, I can no longer run my program on another pc without installing it. I attached an image of the exception message. If anybody can help I would really appreciate it!
A:
Looks like there is a difference in the MS SQL Installation between the two PC's.
The Dll that is missing is part of MS SQL, therefore either SQL Server is missing completely from the second PC, or there are some options that were not installed on the second PC.
Shiraz Bhaiji
2009-12-08 21:09:29
Its connecting to a remote server and neither of the pcs have sql installed on them.
broke
2009-12-08 21:10:09
Does one of them have SQL Server Client tools installed?
Shiraz Bhaiji
2009-12-08 21:12:19
No they don't ---
broke
2009-12-08 21:15:01
When you added the new reference, where did you add it from?
Shiraz Bhaiji
2009-12-08 21:16:55
http://devpinoy.org/blogs/keithrull/archive/2006/06/08/Programmatically-List-All-SQL-Servers-And-Their-Databases-Using-SMO-.aspxI got it from that website then grabbed the dll from his bin folder
broke
2009-12-08 21:20:05
OK. The naming of the dll is confusing since it looks like a Microsoft dll. But if it is generated from that project, you have to mark the reference with copy local = true, when you copy it to the other machine make sure that you also have the dll in your error message.
Shiraz Bhaiji
2009-12-08 21:42:06
I thought of the same thing, so I did set the copy local = true, but that still didn't fix it. Do you think there is a specific way to add this particular reference?
broke
2009-12-08 21:45:58
+1
A:
- Check the manifest file to make sure the filename is correct.
- Copy the code into your own executable and don't use a DLL.
- Turn Copy Local property to false.
Dew Stuff
2009-12-11 00:35:26