The Provider property of the dataset is an interface of type IProvider. A TProvider is not required, you can just use DataSet.Provider. Look at TDBDataSet.GetProvider for how it gets the IProvider. TProvider is useful, if you need any of the events. This example will open a client dataset looking at a TTable on the same form.

?

uses BDEProv;
...
procedure Button Click(Sender: TObject);
begin
  ClientDataSet .Provider := Table .Provider;
  ClientDataSet .Open;
end;
?