Can I connect to multiple servers with an asp:SqlDataSource?

Question

I have a repeater table in an asp.net application bound to an asp:SqlDataSource, and I need that data source's SelectCommand to select data from two databases in different servers.

I've been using the ConnectionString property of SqlDataSource to establish a connection to a single server, but I'm unsure of how to establish a link to multiple servers. Is this possible?

this is a little confusing. please provide what you're trying to do exactly, with code parts, database tables etc. — İsmet Alkan
– İsmet Alkan, Commented Oct 23, 2014 at 14:52
I haven't tested/tried so see if this works. The idea is that your db query does the extra connection and action (your sqldatasource will still just need one conn). Again, haven't tried. You can help the community by posting result if successful. Hth... — EdSF
– EdSF, Commented Oct 23, 2014 at 15:24

Nader Khazai · Accepted Answer · 2014-10-23 15:41:48Z

4

SqlDataSource has one ConnectionString

Two connectionStrings are needed. Make queries using each one and combine, sort or process the result in the code and then use the result for the data source of the table.

edited Oct 23, 2014 at 15:41

answered Oct 23, 2014 at 15:32

Nader Khazai

1856 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can I connect to multiple servers with an asp:SqlDataSource?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related