Using the toolkit from a webservice
Brian Donahue
Posts: 6,590 Bronze 1
Hi Paul,
There are two things that you need to build a webservice. One is the
licenses.licx file which tells the licensing which Red Gate assemblies are
being referenced, and a 'SQL Toolkit.lic' file. You can produce a SQL
Toolkit.lic file by building a 'dummy' console application, just to get the
licence requester up so that you can go through the product activation,
which will produce the SQL Toolkit.lic file.
Regards,
Brian Donahue
Red Gate Technical Support
"Paul Buxton" <psb@NOSPAMspireite.demon.co.uk> wrote in message
news:1quozqqe07q7i$.6g80fiqx08g5$.dlg@40tude.net...
> Hi,
>
> Let me clarify what we are doing here.
>
> We have a webservice, which calls a C# class. This c# class uses the
> toolkit to compare two local databases.
>
> Obviously the webservice runs under the ASPNET user. On attempting to
> create the ComparisonSession object, I recieve
>
> "System.InvalidOperationException: It is invalid to show a modal dialog or
> form when the application is not running in UserInteractive mode. Specify
> the ServiceNotification or DefaultDesktopOnly style to display a
> notification from a service application."
>
> This suggests that I can't use the Toolkit in a webservice, ond only from
> true windowed application. Any workaround?
>
> Thx.
>
There are two things that you need to build a webservice. One is the
licenses.licx file which tells the licensing which Red Gate assemblies are
being referenced, and a 'SQL Toolkit.lic' file. You can produce a SQL
Toolkit.lic file by building a 'dummy' console application, just to get the
licence requester up so that you can go through the product activation,
which will produce the SQL Toolkit.lic file.
Regards,
Brian Donahue
Red Gate Technical Support
"Paul Buxton" <psb@NOSPAMspireite.demon.co.uk> wrote in message
news:1quozqqe07q7i$.6g80fiqx08g5$.dlg@40tude.net...
> Hi,
>
> Let me clarify what we are doing here.
>
> We have a webservice, which calls a C# class. This c# class uses the
> toolkit to compare two local databases.
>
> Obviously the webservice runs under the ASPNET user. On attempting to
> create the ComparisonSession object, I recieve
>
> "System.InvalidOperationException: It is invalid to show a modal dialog or
> form when the application is not running in UserInteractive mode. Specify
> the ServiceNotification or DefaultDesktopOnly style to display a
> notification from a service application."
>
> This suggests that I can't use the Toolkit in a webservice, ond only from
> true windowed application. Any workaround?
>
> Thx.
>
This discussion has been closed.
Comments
I took me quite a while to understand the way that the licensing works
myself, so I can sympathize. Reading the white paper from Microsoft about
licensing really helped.
Regards,
Brian Donahue
Red Gate Technical Support
"Paul Buxton" <psb@NOSPAMspireite.demon.co.uk> wrote in message
news:iztfgf872tg6.1vebm3dc7iles$.dlg@40tude.net...
> On Mon, 12 Jul 2004 18:25:46 +0100, Brian Donahue (Red Gate) wrote:
>
> > Hi Paul,
> >
> > There are two things that you need to build a webservice. One is the
> > licenses.licx file which tells the licensing which Red Gate assemblies
are
> > being referenced, and a 'SQL Toolkit.lic' file. You can produce a SQL
> > Toolkit.lic file by building a 'dummy' console application, just to get
the
> > licence requester up so that you can go through the product activation,
> > which will produce the SQL Toolkit.lic file.
> >
> > Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "Paul Buxton" <psb@NOSPAMspireite.demon.co.uk> wrote in message
> > news:1quozqqe07q7i$.6g80fiqx08g5$.dlg@40tude.net...
> >> Hi,
> >>
> >> Let me clarify what we are doing here.
> >>
> >> We have a webservice, which calls a C# class. This c# class uses the
> >> toolkit to compare two local databases.
> >>
> >> Obviously the webservice runs under the ASPNET user. On attempting to
> >> create the ComparisonSession object, I recieve
> >>
> >> "System.InvalidOperationException: It is invalid to show a modal dialog
or
> >> form when the application is not running in UserInteractive mode.
Specify
> >> the ServiceNotification or DefaultDesktopOnly style to display a
> >> notification from a service application."
> >>
> >> This suggests that I can't use the Toolkit in a webservice, ond only
from
> >> true windowed application. Any workaround?
> >>
> >> Thx.
> >>
>
> Yep... fixed before you answered (in my 2nd reply to myself). Wasn't
> immediately apparent though.