Subject Re: [firebird-support] database gone after server reboot
Author Thomas Steinmaurer
> 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
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements
> -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

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