title: Datasnap Delphi XE5 Server side dynamic sql
body: <p>I am having a small problem with datasnap in delphi Xe5.</p>
  
  <p>I need to run dynamic queries on the server side. I am using an ADO connection on the server methods. </p>
  
  <p>Server Procedure: </p>
  
  <pre><code>var
  qryNew: TADOQuery;
  dspNew: TDatasetProvider;
  begin
      qryNew := TADOQuery.Create(nil);
      qryNew.Connection := Adoconnection1;
      qryNew.SQL.Text := SQL;
      qryNew.Name := 'qry'+IntToStr(1);
      dspNew := TDatasetProvider.Create(nil);
      dspNew.Name := 'dsp'+IntToStr(1);
      dspNew.Dataset := qryNew;
      qryNew.Open;
      Result := dspNew.Name;
  end;
  </code></pre>
  
  <p>Client side procedure:</p>
  
  <pre><code>ClientDataset1.ProviderName :=clientmodule3.ServerMethods1Client.GetDataForClient('Select top 10 * from ODBC.trans_day_2009_1111;');
  </code></pre>
  
  <p>On the main form i have a SQLconnection, DSProvider connection and a client dataset. When I try to set the provider name for the client with the above code, i get the error "Remote error: Provider not exported : DSP1"</p>