I there,

I am trying the statement below on a FB 2.5 for Windows test environment. I am pretty sure that USER and PASSWORD are correct, in fact, I can connect to the same database from IBExpert using those values with no issues. But when the code below runs, I get this error:

Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Execute statement error at attach :
335544472 : Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
Data source : Firebird::localhost:altamira.

Any ideas?

Thanks in advance,

-Eduardo


FOR EXECUTE STATEMENT 'SELECT CVE_IMPO,
        CVE_PROV,
        NUM_PART,
        FRACCION,
        DES_MERC,
        PES_UNIT,
        PRE_UNIT,
        ABR_UNI,
        IMP_EXP,
        PAI_ORIG
        FROM VETL_PARTES810'
    ON EXTERNAL DATA SOURCE 'localhost:altamira' AS USER 'sysdba' PASSWORD 'masterkey'
    INTO :cve_impo, ... etc.