Using the toolkit from a webservice

Brian DonahueBrian Donahue Posts: 6,590 New member
edited July 13, 2004 8:38AM in SQL Toolkit Previous Versions
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" <[email protected]> wrote in message
news:[email protected]
> 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.
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Paul,

    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" <[email protected]> wrote in message
    news:[email protected]
    > 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" <[email protected]> wrote in message
    > > news:[email protected]
    > >> 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.
This discussion has been closed.