I need to specify different connection strings for each adapter and I've had a look around and I can't seem to work out if this is possible or not!

using (DataAccessAdapter adapter = new DataAccessAdapter("SQl2000.ConnectionString"))
            {
                adapter.FetchEntityCollection(e.ContainedCollection, e.Filter, e.MaxNumberOfItemsToReturn, e.Sorter);
            }

and

using (DataAccessAdapter adapter = new DataAccessAdapter("SQl2005.ConnectionString"))
            {
                adapter.FetchEntityCollection(e.ContainedCollection, e.Filter, e.MaxNumberOfItemsToReturn, e.Sorter);
            }

Where both are set in the connectionStrings in the web.config

Thanks

Richard

I believe you have to pass in the actual Connection String to the constructor...

DataAccessAdapter adapter = new DataAccessAdapter(
     ConfigurationManager.ConnectionStrings["SQl2000.ConnectionString"].ConnectionString);

BOb