Robert and Helen thanks for you suport. thats works now.

Alexandre
Brazil

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 11:14 AM 31/08/2006, Rob Martin wrote:
> >Hi, my names not Helen but I might be able to help :)
> >
> >Try...
> >
> > ibSession := TIB_Session.Create(nil);
> > ibConnection := TIB_Connection.Create(*ibSession*); //Changed
> > ibtransacao:=TIB_Transaction.Create(*ibSession*);
//Changed
> >
> > ibtransacao.IB_Connection:=ibConnection;
> > ibtransacao.Isolation:=tiCommitted;
> > ibtransacao.IB_Session:=ibSession;
> >
> > ibConnection.DatabaseName := 'MYBASE.GDB';
> > ibConnection.UserName := 'sysdba';
> > ibConnection.Password := 'masterkey';
> >
> >ibConnection.Protocol = cpTCP_IP; //New
> >
> > ibConnection.SQLDialect:=3;
> > ibconnection.DefaultTransaction:=ibtransacao;
> > ibconnection.IB_Session:=ibSession;
> > ibConnection.Connect;
> >
> >
> >You should specify Path and Server instead of DatabaseName. I not your
> >example databasename has no path info in it.
>
> Quite right - except Rob you forgot to include them in your example!
>
> so --
>
> // ibConnection.DatabaseName := 'MYBASE.GDB';
> ibConnection.DatabaseName := 'abcde'; // anything friendly
> ibConnection.Path := 'D:\Path\To\MYBASE.GDB';
> ibConnection.Server := 'localhost';
> ibConnection.UserName := 'sysdba';
> ibConnection.Password := 'masterkey';
>
> ibConnection.Protocol = cpTCP_IP; //New
>
> Note, if you leave Server, Path and Protocol blank, you can use
> DatabaseName (not recommended though) but the entire,
> protocol-correct connection string is required, viz.
>
> ibConnection.Path := 'localhost:D:\Path\To\MYBASE.GDB';
>
> Also, if you are using Firebird v.1.5 or higher, it is recommended to
> make use of the database aliasing feature. In that case, replace the
> Path element with the alias, e.g.
>
> In aliases.conf:
>
> mydb = D:\Path\To\MYBASE.GDB
>
> Then, in IBO:
>
> ibConnection.Path := 'mydb;
>
> Please do not hijack other people's topics !!!
>
> Helen
>