--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 08:31 AM 23/03/2007, you wrote:
>
> > > >But I get the following message : ISC 335544344 I/O ERROR for
> > > >file "cocagnePROD". Error while trying to open file. Le fichier
> > > >spécifié est introuvable.
> > > >Here is the code :
> > > > With DM_Cocagne do
> > > > begin
> > > > with IB_Connection1 do
> > > > begin
> > > > Connected := False;
> > > > Server := 'localhost';
> > > > Path := 'cocagnePROD';
> > > > Protocol := cpTCP_IP;
> > > > Username := 'SYSDBA';
> > > > Password := 'masterkey';
> > > > LoginPrompt := false;
> > > > DefaultTransaction := IB_Transaction1;
> > > > Connected := true;
> > > > end;
> > > > end;
> > > >I use firebird 1.5 and IBO.4.6. cocagnePROD is an alias from
> > > >ALIASES.CONF.
> >
> > > >Here is the path in ALIASES.CONF :
> > > >cocagnePROD = C:\DataCocagne\BDCOCAGNE_GPROD.FDB
> > > >
> > > >Does some one has a solution ?
> > >
> > > 1. Are you using the embedded server?
> >
> >No. I know the embedded version works only with local protocol.
> >
> > >
> > > 2. If not, does it change anything if you use
> > > 127.0.0.1 in the Server property, instead of localhost?
> >
> >I tried by with no success. and same error message.
>
> What happens if you put the whole database path
> into the Path property, instead of the alias?
>

It works.

> Note, also check the DatabaseName property of the
> IB_Connection and make sure it doesn't contain
> the old IPC path. Change this property to something harmless, such

as CN.

>
> Do some similar housecleaning on the Params
> property of the IB_Connection - clear out everything that is there.
>

I did it but it does change the problem.

> Still....because you say you had the same problem
> with ISQL, one is tempted to suspect that the
> database file is not in the place where you think
> it is....so re-checking the spelling of
> everything would be a worthwhile exercise if you haven't already

done that.

>

The alias 'cocagnePROD' from aliases.conf works with a local protocol.
The database is at the right place.
It is as if when changing for TCP_IP protocol, the file aliases.conf
cannot be found. Could it be possible ?

> Helen
>