Help with an error message.

[fmeads]

I wrote a command line script app using the toolkit. I installed it on a co-workers machine and get the following error message.

Could not load file or assembly 'RedGate.SQLCompare.Engine, Version=6.2.1.36, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified.

I verified the ReGate files where in the system32 directory and ran regasm command to register them on my co-workers machine. Still getting the error message. Any help would be appreciated.

[Brian Donahue]

Hi,

Thanks for your post. You don't need to register any of the RedGate assemblies or place them in the system32 folder; in fact I'd recommend avoiding this as it could introduce problems when we upgrade the assemblies.

More than likely there is a missing dependent assembly. When you distribute a SQL Toolkit application, you have to distribute the assemblies specified in the Toolkit documentation.

The other possibility is that you use the Data Compare engine. If you are using the Data Compare API, you need to ensure that all of the assemblies come from the SQL Data Compare distribution because the dll versions vary between the SQL Compare and SQL Data Compare distribution so that the Data Compare dlls all need to be kept in the same directory as your console application.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[fmeads]

Added the missing assemblies. Now when I try to run my app on my co-worker's machine it wants to activate toolkit again.

[Brian Donahue]

Hi,

That usually indicated that the licensing that was supposed to take place when you built the project was not entirely successful. Maybe having a glance at our troubleshooting document will help.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521