Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

two connection strings for sqldatasource

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
0
RecipeDan
Asked:
RecipeDan
1 Solution
 
rockiroadsCommented:
Didn't think it was possible. If you don't find any joy see if you can use this workaround.

are you able to create a stored procedure which runs this query joining two databases?
if so then could you not set one up and use that? Of course they can be parameterised as well


Stored Procedues http://support.microsoft.com/kb/306574
More info http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/sqldatasource.aspx

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now