OraDataSource and OraProvider advantages

thvedel · Post by **thvedel** » Wed 01 Feb 2006 11:07

Could anyone point out if there is any advantage by using the OraDataSource and OraProvider components compared to the standard Delphi DataSource and DataSetProvider components? They appear to be quite similar.

I have bought the ODAC NET components, which does not include the component source, so I can not check it out myself.

Best regards
Thomas Vedel

Challenger · Post by **Challenger** » Wed 01 Feb 2006 13:28

To know the difference beteween TOraDataSource and TDataSource please see
http://crlab.com/forums/viewtopic.php?p=2008#2008
As to TOraProvider, it was implemented to avoid some problems that persist in Delphi 4 and 5. If you use older version of Delphi then there is no difference between TOraProvider and TProvider.

thvedel · Post by **thvedel** » Wed 01 Feb 2006 13:53

challenger wrote:As to TOraProvider, it was implemented to avoid some problems that persist in Delphi 4 and 5. If you use older version of Delphi then there is no difference between TOraProvider and TProvider.

Please forgive that I am not sure I understand your answer correctly.
Does this mean that the recommended provider component in multitier applications is TDataSetProvider? (I think that TProvider is not included in recent versions of the VCL).

I am using Delphi 7 and 2006.

Best regards,
Thomas

Challenger · Post by **Challenger** » Wed 01 Feb 2006 14:14

Sorry for misprint. I meant TDataSetProvider. However, TProvider class exists in Delphi 7, 2006 for backward compatibility.

thvedel · Post by **thvedel** » Wed 01 Feb 2006 14:20

Thaks for clarifying.
I think I will then choose TOraDataSet and TDataSetProvider for maximum flexibilty and compability with future enhancements