I have multiple connectionString's to multiple databases in my web.conf. I do this to query multiple databases from a single query page. This query is past thru a url to another page (asp.net 2 with .vb page behind; no code in page behind presently), which contains the query info or sqldatasource. This page contains numerous sqldatasource due to querying multiple databases.
My problem arise's if one of the databases is down. This prevents me from searching the other databases (error, because no connection string).
My question is: Is there a way to create a checkbox for each connectionString or sqldatasource allowing me to select the database to search. This would help if a database is unavailable; simply unchecking that database would allow me to search the other databases without error message.
If so can anyone kindly assist. I am not advanced in vb but have an understanding.
I had a similar post with opposite request if you check ...
Go to the complete details ...