<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
Is it possible to have two connection strings for sqldatasource? <br />
<br />
I have a Select statement that Inner Joins two databases. When I run the page I get an invalid column error, however; when I run the statement in sql management studio it runs fine. So I am thinking that the error is caused by not connecting to the second database.<br />
<br />
Dan
</div>
</div>


Hello:

Is it possible to have two connection strings for sqldatasource? 

I have a Select statement that Inner Joins two databases. When I run the page I get an invalid column error, however; when I run the statement in sql management studio it runs fine. So I am thinking that the error is caused by not connecting to the second database.

Dan

two connection strings for sqldatasource

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications