Subject [firebird-support] Connection giving error - "isc_attach_database failed"
Author Rishi Ravindran
isc_attach_database failed

The user does not have permission to perform this operation on this
object.

Engine code: 335544352
Engine Message: no permission for read-write access to database



1. My application uses Firebird database. I have an installed and a
source code version of it. There is a separate database created and
used locally in each (debug and installed versions) application
directory.

2. Debugging the source code version of the software and doing an
extended run of it somehow corrupted its local copy of the database.

3. Now, I am unable to connect to it from the source code version
application and gives the following error when I do so from
FlameRobin and Firebird ISQL,

------------------------------------------------------------------

isc_attach_database failed

The user does not have permission to perform this operation on this
object.

Engine code: 335544352
Engine Message: no permission for read-write access to database

------------------------------------------------------------------


4. After moving the corrupt database from the debug applcation
directory to the install directory and trying a connect from there
fails with the same error hence confirming the fact that the database
is indeed corrupt.

5. Now this is peculiar. Moving the non-corrupted database from the
install folder to the debug application folder still gives the same
error. I thought earlier that just the database was corrupted.

6. Deleting the corrupted database from the debug directory and
trying to create a new database at the same location gives the
following error,

"Error string not found for error no 24"

Once again this makes me think that somehow the directory is also
affected because of the corrupted database.


Please give suggestions/resolutions if any.