Subject Re: [IBO] Configure IBO with remote datamodule
Author Helen Borrie
At 09:01 PM 24-11-02 +0000, Sammy Davis wrote:
>Hi all,
> How can i use IBO with a remotedatamodule?

Use the TIBO* components - see the iboTDataset palette. Delphi's
TDatasetProvider needs a TDataset-compatible dataset for its Dataset property.

>
> I'm using only one Tib_connection per remotedatamodule in my
>application .

Use a TIBODatabase component instead. Set its properties as follows:

Server: localhost
Path: d:\mypath\mygdb.gdb MUST BE A PHYSICAL PATH, NOT A SHARE
Protocol: cpTCP_IP

also set the PasswordStorage, User and Password properties, e.g. using your
previous examples:
PasswordStorage: psNotSecure
User: sysdba
Password: masterkey

Use a TIBOQuery as your dataset. Set its DatabaseName property to your
IBODatabase.

Connect your IBOQuery to the TDatasetProvider's Dataset property.
>
> If two or more clients connect to my server its lock.
> Initially my client application is very simple. I need refresh a
>sql select statement result in one to one second using a timer.

Why are you doing this on a timer? How can you be certain that one refresh
completes before the next one begins? What code do you use for this?

>
> I need use a TIB_Transaction or TIB_Session ? If yes how can i
>configure it ?

By default, your datasets will use the default transaction of the
IBODatabase. If you *need* to use multiple transactions, use TIBOTransaction.

The IBODatabase uses a default session. If you want to access the
properties of the default session, use a TIB_SessionProps.

You won't need to use explicit TIB_Session components unless you are
multi-threading your server application, e.g. you are making it an ISAPI
module. I think you need to keep away from multi-threading until you get a
better understanding of the remote data module architecture.

Helen