Subject Re: [IBO] Losing TIB_Connection whilst designing
Author tickerboo2002 <support@tickerboo.com>
Helen

> This combination should persist, even if the client loses its
connection to
> the database (names used here are for example only):
>
> TIB_Connection, properties
> Name property set to CN
> Path property set to c:\data\MyDb.gdb
> Protocol property set to cpLocal
> DatabaseName property set to MyDb (thus overwriting the duplicated
server +
> path (path alone in the case of the local connection).

<snip>

Your method is how I currently work.

>*Don't* use the DatabaseName property. It is there for
> VCL compatibility and may not fully abstract the object reference,

All of my queries/cursors have the IB_Connection and the DatabaseName
property set (I assume the datbasename gets filled in
automatically). I assume this is ok, provided the IB_Connection
property is filled.

One query: Why do I have to set the connection for both the
transaction and the query? If a query's IB_Connection property is
set to <default> does this use the transaction's connection?

> To avoid the blackouts, don't use cpLocal, use cpTCP_IP and Server
> localhost, an arrangement known as "TCP/IP local loopback". Make
sure
> localhost is defined in your HOSTS file.

Just implemented, thanks.

David