title: How to pass parameters for OPENDATASOURCE
body: <p>I can connect to a linked server with this:</p>
  
  <p>SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo 
  FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.150.42;User ID=readerUser;Password=1').akreditasyon.dbo.tblPerfCevap</p>
  
  <p>But I have to pass the password as parameter. and I try like this: </p>
  
  <p>SET @connectionString = 'Data Source=192.168.150.42;User ID=readerUser;Password='+@pw</p>
  
  <p>SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo 
  FROM OPENDATASOURCE('SQLOLEDB', @connectionString ).akreditasyon.dbo.tblPerfCevap</p>
  
  <p>and</p>
  
  <p>SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo 
  FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.150.42;User ID=readerUser;Password='+@pw ).akreditasyon.dbo.tblPerfCevap</p>
  
  <p>but didnt work:S</p>
  
  <p>does anyone have an idea?</p>