I'm trying to get embedded SQL to work against the embedded server on
Windows XP, using the examples that come with Firebird (stat2.e in
particular). I tried this:

[bin]$ ./gpre.exe -c -d employee.fdb stat2.e
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.

Then I tried putting the following at the top of the file:

EXEC SQL
BEGIN DECLARE SECTION;
EXEC SQL
SET DATABASE DB1 = 'employee.fdb';
EXEC SQL
CONNECT DB1 USER 'SYSDBA' PASSWORD 'masterkey';
EXEC SQL
END DECLARE SECTION;


And got:
[[bin]$ ./gpre.exe -c stat2-mod.e
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
(E) stat2-mod.e:42: Couldn't access database DB1 = 'employee.fdb'
(E) stat2-mod.e:49: No database specified


Can anybody help?

Note: the employee.fdb database is in the bin directory, as is my
source file, so everything is in the same place.
And I can connect fine to employee.fdb as SYSDBA using isql.

Thanks in advance.