Licensing Errors!

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Licensing Errors!

Postby Dinny7478 » Mon Oct 04, 2010 4:31 pm

I am working on an application that uses the SQL Data Compare SDK but have faced problems in trying to licence the dll's.

The dlls were originally installed but had expired before we got round to obtaining a licence key. We now have a licence key and have created the licenses.licx file which contains the following entries:

RedGate.SQLCompare.Engine.Database, RedGate.SQLCompare.Engine
RedGate.SQLDataCompare.Engine.ComparisonSession, RedGate.SQLDataCompare.Engine

However when the application is built the nag screen appears stating the the trial has expired. There is an option to activate it but clicking on this results in the same nag screen appearing again. Again clicking on the Activate command appears to do nothing.

No screen appears where we can enter a serial number, instead we are seeing the following build errors:

Exception occurred creating type 'RedGate.SQLCompare.Engine.Database, RedGate.SQLCompare.Engine, Version=8.0.0.309, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' System.IO.FileNotFoundException: Could not load file or assembly 'RedGate.Licensing.Client.resources, Version=2.7.0.6, Culture=en-US, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. Thesystem cannot find the file specified.

Exception occurred creating type 'RedGate.SQLDataCompare.Engine.ComparisonSession, RedGate.SQLDataCompare.Engine, Version=7.1.0.230, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' System.IO.FileNotFoundException: Could not load file or assembly 'RedGate.Licensing.Client.resources, Version=2.7.0.3, Culture=en-US, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified.

Any Ideas? We are truly stuck now!
Dinny7478
 
Posts: 2
Joined: Mon Oct 04, 2010 4:14 pm

Postby Brian Donahue » Tue Oct 05, 2010 6:18 pm

Hi Dinny,

We have seen this issue about 5 times now, but are unable to find the cause. Visual Studio is acting just plain crazy because the .resources.dll file does not exist and is not part of the SQL Comparison SDK.

Here are some things that have worked to get around it:
  • Locate the SDK samples on disk (v8 comes with samples) or create a new VS project with a very minimal bit of code that refers to the RedGate.SQLCompare.Engine and create licenses.licx in that and build it.
  • Use the Red Gate Machine Hash Utility and activate the SDK on the command-line (see the readme in the ZIP for the usage).


Hopefully one of these will get the SDK activated so you can use it.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Dinny7478 » Wed Oct 06, 2010 4:06 pm

Trying the Machine Hashutility to try and get the activation sorted but have ran into another problem.

Using the command:
MachineHashUtility /MACHINEHASH:XXXX-XXXX-XXXX-XXXX /ACTIVATE /PRODUCT:\"SQL Toolkit\" /SERIALNUMBER:XXX-XXX-XXXXXX-XXXX
/MAJORVERSION:8 /TESTONLY

Generates the Request
<activationrequest>
<version>3</version>
<machinehash>XXXX-XXXX-XXXX-XXXX</machinehash>
<productcode>31</productcode>
<majorversion>8</majorversion>
<minorversion>0</minorversion>
<serialnumber>XXX-XXX-XXXXXX-XXXX</serialnumber>
<session>4b8f3f82-cf59-4b82-9fb1-be02786df477</session>
<locale>en-US</locale>
</activationrequest>

We get the following response:
Server said: <Error>
<Title>This serial number is not for PST Importer 2010</Title>
<ManualButton show=\"false\"/>
<Description><p>This serial number is for SQL Toolkit 8.<br/>
<br/>
Check the serial number that was sent to you with your invoice.<br/>
<br/>
If you cannot find your serial number, you can retrieve it at:<br/>
<a href=\"http://www.red-gate.com/myserialnumbers\">http://www.red-gate.co
m/myserialnumbers</a><br/>
</p>
</Description>
<Help>http://www.red-gate.com/Products/Licensing/v_2/WrongProduct</Help>
</Error>

Am i using the correct Product Name?
Dinny7478
 
Posts: 2
Joined: Mon Oct 04, 2010 4:14 pm

Postby Brian Donahue » Wed Oct 06, 2010 6:14 pm

The product name had been changed to \"SQL Comparison SDK\" a few years ago. If you enter it correctly, the \"productcode\" in the request should be \"8\".
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Licensing Issues

Postby mwatkins@xsinc.com » Mon Nov 01, 2010 7:01 pm

Hello,

I just purchased the SQL Compare SDK and am having the same licensing issue described here. Using Visual Studio 2010. I tried the MachineHash utility and it shows that my product is activated now but I still get a nag message that states that I only have two days left to activate.
mwatkins@xsinc.com
 
Posts: 3
Joined: Mon Nov 01, 2010 6:57 pm

Postby Brian Donahue » Mon Nov 01, 2010 7:03 pm

Hello,

If you get the nag requester when you deploy the app, then it did not licence correctly during the build. Try re-creating licenses.licx again.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests