Subject Re: Operating System Directive Createfile failed
Author jusworkn2liv
We use Interbase Express and ADO Objects to connect. The firebird
client we use is version, firebird embedded.

This error most commonly occurs on startup of computer on both
Windows XP and Windows 2000 Professional. Our app is tied to the
windows system login.

Thanks for your help.

--- In, Helen Borrie <helebor@...>
> At 06:39 AM 24/05/2006, you wrote:
> >I get the error "Operating System Directive Createfile failed"
> >opening a Firebird database. I have tried looking this error up
> >the internet and was not able to find anything that would help.
> >user accessing the database does have read/write permissions on
> >directory where the database resides.
> Unless your appl is creating the database, permissions on the
> database directory are not the issue here. If the database exists
> and can sometimes be opened, the I/O error doesn't concern the
database file.
> The "user accessing the database" (from the POV of the operating
> system) will be (by default installation settings for services)
> OS user 'firebird" on Linux or 'localsystem' on Windows. On Linux
> that user also needs execute permissions on any directory in which
> is likely to create a file.
> However --
> On Windows, if you are running the Firebird server as an
> (this includes Fb embedded), the logged-in OS user will be the
> of the server process and filesystem permissions would then apply
> anything the server had to create in the filesystem.
> On Linux if you are running Classic and connecting locally then,
> again, the logged-in OS user owns the process and you will bump
> FS permissions.
> >This error does not occur
> >everytime we attempt to open the database. Can someone tell what
> >is being created when Firebird starts and in which system
> In the Firebird root directory, the server creates various files
> startup - '.LCK'
> files in some cases; 'firebird.log' if it doesn't already
exist, etc.
> >
> >And what else could be causing this error to occur intermittently
> >the same pc?
> If the firebird.log file is being deleted intermittently then the
> server will have to recreate it next time it wants to write a log
> record. Maybe you have some cron job (or batchfile) that deletes
> log? And there is a permissions problem preventing the
> recreation...or whatever.
> If memory resources are low, the server will also use the disk to
> hold sort files. Of course, it needs to create these files. Maybe
> your data access layer does some kind of ordered query on the
> tables when a client logs in. If you haven't configured some disk
> space for this it will try to use the /tmp directory (Linux) or,
> Windows, whatever directory is configured as the TEMP directory.
> disk resources are also marginal, and the server can't find enough
> space there to write the sort files, you could get an I/O error
> then. Likewise if you don't have a TEMP directory configured on
the OS at all.
> But really you have given us a needle in a haystack - no
> of your operating system platform, Fb server model, environment,
> what kind of connection is being attempted.
> ./heLen