Subject Re: Select Top n ???
Author adele_leroux
I know Free and Good does usually not go together, but are there any
Free and Good firebird components available? Where can I look?

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
> 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