Hi,

> We have solved the problem (sort of) and caused another. The
> database was registered incorrectly in IB Expert (using the
> Interbase client dll and not FB client dll). Thanks for your help
> and to Tim. The query select first... does now work in IB Expert,
> but not from our delphi application. We are using the Interbase
> components in Delphi, which I assume is the problem. Is there any
> possible way to fix this?
>
> The other problem we are facing now is that we cannot access the
> same database from IB Expert and our delphi application (either run
> or design time) at the same time. The error...
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> I/O error for file "C:\DB.FDB".
> Error while trying to open file.
> The process cannot access the file because it is being used by
> another process.

Apparently, the InterBase server is using the datafile instead
of the Firebird server. Or the other way around.

Use Firebird components and make sure to use fbclient.dll.
The InterBase component will get less compatible with every
release of InterBase and/or Firebird.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com