[firebird-support] External Data Source Authentication Issue

[eadbha...@yahoo.com.mx [firebird-support]]

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.