Three-tier sample code

[Oswaldo]

I'm new in three tier applications.
What I need is to have a TOracleSessionPool in a middle tier for clients to connect with it and not login and logoff each time a new user needs to connect to the database. Is it possible to do what I need without using MIDAS?
Any suggestions, links, sample code will be greatly appreciated.
Thanks in advance,
Oswaldo Hitti

 

[Marco Kalter]

You will need something like MIDAS. There are several MIDAS alternatives, such as ASTA or DbOvernet.

 

[Oswaldo]

Thanks,

Are there some alternative that let me connect the TOracleNavigator to the DataSet to take advantage of the query by example properties?

If I use Midas, I need a TClientDataSet and TOracleNavigator does not support a connection to a clientdataset.

Thanks again,
Oswaldo.

 

[Marco Kalter]

No, the TOracleNavigator is a visual control that can only be used with a TOracleDataSet.