XModPro

2 SQL Servers connection string

Cata Cata asked Feb 6, 2017
Active Feb 6 · Viewed 2694 times
<p>Hi, </p> <p>I had the situation where I had to access 2 separate SQL data sources at once: one of the local DNN and another one form a remote location. </p> <p>How I would connect in that situation? This does not work </p> <p><span class="Apple-style-span"><span class="Apple-style-span"></span></span> </p> <blockquote>&lt;SelectCommand ConnectionString="Data Source=externalIP;Initial Catalog=splendid;Persist Security Info=True;User ID=is;Password=pass" "Data Source=.\SQLExpress;Initial Catalog=mindmaster;User ID=is2;Password=pass2"<br> CommandText="<br> </blockquote> <p>What I can do when I need to join tables form datasources that are located in 2 remote servers? </p> <p>thank you!<br> </p>

1 Answer

Loading answers...