> How can I attach to a local firebird database? I have a program that was
> originally written for Interbase but I wanted to run it against a
> firebird database. Every time it tries to connect it gets gives the error:
>
> SQL error in Database attach:
> SQLCODE = -902 IN Database attach.
> SQLCODE: -902
> SQL ERROR:
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements
>
> ISC STATUS:
> -Your user name and password are not defined. Ask your database
> administrator to set up a Firebird login.
> Terminating...
>
> I have no problems attaching to that same local database with isql and qli.

Perhaps a different client library gds32.dll/fbclient.dll is loaded?

Are you running InterBase and Firebird in parallel on the same machine?


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.