Working with two databases for single application

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

Re: Working with two databases for single application

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

Re: Working with two databases for single application

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

Re: Working with two databases for single application

Please provide us more details.

As kidshaw said, different situation have different solution.

So please tell use what are your trying to do.

Thanks