Subject Re: [IBO] Classic and IBOBackupService
Author Geoff Worboys
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