Infralution Support

dna · Joined: 19 Oct 2006 Posts: 3

Hi,

All versions since 2.5.x have come with a SQLDB.ZIP, containing SQLserver DB for attachment to SQLServer.

We have now just wanted to start to use MSSQL (2k) after a long while using the Access License database. (Only because we want to do more server side integration).

We are currently using 3.2.1 (upgraded from 3.2.0 today), currently against Access DB.

Q. If I point my license tracker exe.config to SQL server DB attached from the latest 3.2.1 release (dated 08/09/2005 13:12) (Empty tables) I get a 'SYNTAX Error near keyword 'COLUMN' error.

If I upsize the Access DB, into a new sql2k database, I get other syntax errors on startup of LicTracker.

So what I am really asking is: am I using the right SQLDB.ZIP? Is it still functional with 3.2.1.
(The SQL server is remote from the pc running lictrack).

Finally if/when i get SQL working with 3.2.1, is there a preferred way to import the Access data, or do I have to manually import/export from Access with the constraints/identities off.

PS: At 3.2.1 our customgenerators stopped working, but a compile under vs2005 sorted it fine - funny though, as 3..0.0+ worked fine under vs2003 compiled generators?

Infralution · Joined: 28 Feb 2005 Posts: 5027

Infralution · Joined: 28 Feb 2005 Posts: 5027

OK we now have a fix out for this (Version 3.2.2). This also includes new SQLDB files for the current version.

The Access Upsizing wizard still seems to have issues with the way it converts some of the table definitions - so you are probably better off using the SQLDB tables included in the new release (3.2.2) and then importing your data.
_________________
Infralution Support

dna · Joined: 19 Oct 2006 Posts: 3

Guys,

Its nice to post a message, go to sleep, wake up next day and have a solution waiting when you start up the pc.
(I guess the time diff works to my advantage also)
Big round of applause to Infralution Very Happy

dna · Joined: 19 Oct 2006 Posts: 3

A small word of warining:

The included SQLDB.zip for 3.2.2 will only attach correctly to SQL2005, not SQL2000 - not really a major problem for me, but for others could cause pain. Quick/dirty solution is to generate script, and use that to build on SQL2000, and add needed rows - found import/export from 2005->2000 causes problem for LicTrack (exception LargeChange - using value -1, needs > 0). Copy DB wizard fails also, but that a M$ prob with wizard between 8.0/9.0 sql servers.

Hope this helps someone else

kiter · Joined: 23 Nov 2006 Posts: 1

Infralution · Joined: 28 Feb 2005 Posts: 5027

Did you get a response from DNA? We've generated a script that you can download from here. Let us know how you go.
_________________
Infralution Support

Infralution · Joined: 28 Feb 2005 Posts: 5027

There were a few issues with the script in the previous post. Thanks to kiter we have now put a zip file with SQL2000 compatible mdf/ldf files that you can use in our download area here.
_________________
Infralution Support

bpieslak · Joined: 05 Mar 2007 Posts: 6

Hi. I read through this thread and downloaded the latest SQL2000DB.zip file.

The LicenseTracker launches, and I am able to create a new Customer and a new Distributor.

When I try to create a new Product, I get a NullReferenceException at Infralution.LicenseTracker.Product.get_KeyStrength()

Has anyone else encountered this problem?

Thanks
-Brian

Infralution · Joined: 28 Feb 2005 Posts: 5027

Are you using the latest version of License Tracker? This sounds a lot like a bug that was fixed in a previous version.
_________________
Infralution Support

bpieslak · Joined: 05 Mar 2007 Posts: 6

According to the Help > About menu option, I'm using 3.2.0.0.

In the downloads area of the website, it looks like I'm behind a version, since the latest version is 3.2.4.

I'll download the latest version and let you know if that fixes it.

Thanks,
Brian

bpieslak · Joined: 05 Mar 2007 Posts: 6

ok. The version 3.2.4 fixed my issue.
Everything is working fine now.

Thanks for the help,
Brian