Subject RE: [firebird-support] Connection giving error - "isc_attach_database failed"
Author Nigel Weeks
It sounds very much like filesystem permissions on the directory holding the
database...
Check that the 'firebird' user has read/write access to the directory, AND
the database files themselves.

N

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of Rishi Ravindran
> Sent: Wednesday, 2 August 2006 3:45 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Connection giving error -
> "isc_attach_database failed"
>
>
> 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.
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>