Red Gate forums :: View topic - User-specific error - license related?
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

User-specific error - license related?

Search in SQL Toolkit Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 28 Feb 2008
Posts: 1

PostPosted: Thu Feb 28, 2008 5:53 am    Post subject: User-specific error - license related? Reply with quote

I recently wrote some .NET code that uses the Red Gate API to compare databases on two different servers (QA and Prod) and synchs data from QA to Prod if there are differences found.

The code works great in testing and I was able to run it without a problem on live data, but other users are having problems running it. The .exe resides on the QA SQL server and it's being run from the command prompt on that server, and the problem seems to occur when any login other than mine is used to connect to the server. The error boils down to the fact that this line works fine when I run it, but returns Nothing when others run it:

Private p_sourceDb As New RedGate.SQLCompare.Engine.Database

I should point out that I'm not getting any kind of errors when building or running the code along the lines of assemblies not being found.

Is there something I need to do to ensure that any user on the server will be able to run this code? Is this even related to the license at all?
Back to top
View user's profile Send private message
Brian Donahue

Joined: 23 Aug 2004
Posts: 6678

PostPosted: Thu Feb 28, 2008 11:43 am    Post subject: Reply with quote

The problem that you describe indeed seems to be a licence issue. I'd guess that you had licensed the Red Gate tools on the computer and the application is somehow picking up on some licence information saved in your user profile. If the application had been properly licensed it would work for everybody because it's not going to check for any Toolkit licenses on the machine if one is found embedded in your executable.

The kicker is that if the licensing is never invoked, you won't get any errors at build-time, so you wouldn't know if the licensing was successful or not.

If you're building the project using Visual Studio, this other post may be helpful.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group