Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 23, 2012 08:13 AM by Dino He - MSFT
May 21, 2012 12:10 PM|LINK
Hi...I wanted my application to work with two databases stored in different location. How to make it work? And what all changes need to be made in the Code? I m using ASP.NET 1.1
May 21, 2012 12:16 PM|LINK
If by two databases you are working with two seperate database that contain unique data and structure then...
You need to add your second database connection string to your config. You will need to change your data access layer to reference the appropriate connection string depending on the database that is required.
If you mean two databases acting as replicas then...
Set up mirroring between the two databases and add 'Failover Partner=<secondserver>' to your connection string
May 21, 2012 12:24 PM|LINK
may we know whats is problem your are facing is it different sources meaning Sql Server and Oracle ?
then using Microsoft Enterprise Library for Data Access will help
May 23, 2012 08:13 AM|LINK
Please provide us more details.
As kidshaw said, different situation have different solution.
So please tell use what are your trying to do.