Infralution Support

[HYC]

Hi,

I validate the new version of ILS. We would like to use SQL Server 2005 for storing licensing information. After I modified the connection string to use the SQL Server, I get an Unhandled Exception when creating a new sale:

"An unhandled exception occured in Infralution License Tracker. Please contact Infralution and provide the information below:

Exception Type: COMException
Message: Incorrect syntax near '*',

Stack Trace:
at ADODB.ConnectionClass.Execute(String CommandText, Object& RecordsAffected, Int32 Options)
at Infralution.LicenseTracker.LicenseTracker.LicenseDatabase.Execute(String command)
at Infralution.LicenseTracker.LicenseKeyScale.Delete(Sale sale)
at Infralution.LicenseTracker.SaleDialog.ClearLicenses()
at Infralution.LicenseTracker.SaleDialog.GenerateLicenses()
at Infralution.LicenseTracker.SaleDialog._generateLicenseButton_Click()
..."

Do you know this problem ??

Can you help me ?

Thanks HYC

[Infralution]

Thanks for reporting this issue. We have now released Version 4.0.2 which fixes this issue with the SQL Server database integration.
_________________
Infralution Support

[HYC]

Thanks for the fast help ! Now it works.

I get a new error:
I tried to extend the key and product info length. Therefore I resized the length of the columns [LicenseKey].[Key] and [LicenseKey].[ProductInfo] to 4000 characters and changed LicenseTracker config file to
<add key="MaxLicenseKeyLength" value="4000" />

After these changes I tried to create a new key with complex ProductInfo using a CustomGenerator. I get the following unhandled exception:

Exception Type: COMException
Message: Operation failed. The index entry of length 1078 bytes for the index 'Key' exceeds the maximum length of 900 bytes.

"Stack Trace:
at ADODB.RecordsetClass.Update(Object Fields, Object Values)
at Infralution.VirtualData.VirtualRecord.Update(Recordset recordset, Boolean refreshRecordset)
at Infralution.VirtualData.VirtualRecord.Update(Boolean refreshRecordset)
at Infralution.LicenseTracker.LicenseKey.GenerateKeys(Distributor distributor, Product product, Customer customer, Sale sale, Int32 numberOfKeys)
at Infralution.LicenseTracker.SaleDialog.GenerateLicenses()
at Infralution.LicenseTracker.SaleDialog._generateLicenseButton_Click()
....
"

Did I forget to modify any additional configuration ?

Can you help me ?

Thanks HYC

[Infralution]

You can't just change the MaxLicenseKeyLength parameter in the config file to 4000 - you'd have to change the size of the actual database field (using SQL Server Management Studio). The default size of the Key field is 900 - because this is the maximum size that SQL Server supports with an index. If you want a field larger then this you can change it in Management Studio and answer yes when asked if you want to remove the index. This may however adversely affect performance when sorting and locating license keys in a large database.
_________________
Infralution Support