Solved

two connection strings for sqldatasource

Posted on 2010-09-21
1
229 Views
Last Modified: 2012-05-10
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
Comment
Question by:RecipeDan
1 Comment
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 33728952
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question