My question is this - is it possible to set a standard value in the
web.config file and change it later based on conditions? Why, you might
ask? I am building a web based application for inter-office usage. It
is an application where software product keys and license keys are
stored and created. We have 1/2 of the office personnel working from
within the domain, and 1/2 that disconnect and work in the field. I am
setting up replication for those that disconnect, but would like to
have them connected to the server when they are here. (That is to allow
them real time connectivity w/o extra work on the server caused by
setting up transactional replication) I hoped to set the db string
(thats the configuration value in web.config) to the large SQL server
if the connection was successful, but to change the connection string
to the MSDE db on their local machine if the prev call failed.
Any insight as to if I can set that value after testing the
connections, whether I can test the connection via c# in the web.config
itself (which I don't think is possible), or a better way that I don't
see?
Any help would be greatly appreciated!!!
Sincerely,
MisC