Subject Re: [IBO] Connection with tcp_ip protocol
Author Helen Borrie
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?

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.

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.

Helen