two connection strings for sqldatasource
Posted on 2010-09-21
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.