Hi Geoff

Thanks very much for your suggestions.

Our system has been working well with FB SS for some time. We really
only wanted to ensure we were working OK with Classic so we could use it
at multi-CPU sites, until Vulcan / FB 3 arrives. I had already followed
your suggestion and discovered my fixes for classic had broken SS
support. So in the mean time we are abandoning support for Classic.

I feel the problems could be related both between the version of IBO we
are using (old) and the version of Firebird 1.5 we are using (also
old). We plan to upgrade both as soon as we have released the latest
version of our software as doing so now would involve a major amount of
re testing.

So my thanks to you and Helen of your help on my issues but for now its
back to super Server :)



Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Geoff Worboys wrote:

>
> Hi Robert,
>
> I believe Helen is away for a few days. Thought I would try
> to offer a couple of suggestions in her place.
>
> I am not really familiar with the IBOBackupService, not even
> sure who wrote it. I use my own DBak utility. But maybe I
> can still come up with some ideas.
>
> > I believe I have found some (or all of the issues here).
> > Bearing in mind that the system originally worked fine with
> > FB SS.
>
> Might I suggest that you go back to SS temporarily and test
> that you can get it to work with the changes you have made
> so far.
>
> > I needed to put double quotes " around both backup and
> > database names (they had spaces in them). This doesn't seem
> > to be a requirement for SS.
>
> An API call should not need quotes around the database name.
> If the database name appears inside a script execution then you
> will need to use single quotes (') and not double quotes.
> If it us used on the command line then double quotes are
> probably the appropriate solution.
>
> > The next issue however is that a screen that ran a script to
> > create a new empty database no longer works. it uses an
> > IB_Script component and under FB classic comes up with
> > 'Invalid CREATE, CONNECT or DROP DATABASE syntax'. This is
> > the same script that works ok under FB SS!
>
> This seems likely to be the double quote issue.
>
> My vote would be to go back to SS and get it all working. Then
> try Classic again and tackle each problem as it arises. Of
> course you are ensuring that you are using a version of FB
> classic that is supposed to support the services API. It would
> be interesting if anyone else here has used IBOBackupService
> with classic successfully.
>
> --
> Geoff Worboys
> Telesis Computing
>
>