Data Access Layer that allows Multiple Data Sources

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Has anyone come across any elegant frameworks that allows writing to
multiple data sources? I'm looking for something that allows a typical
master data source for storing and retrieving data, but I'd also like
it to be able send select data to other datasources. IOW, the other
servers most likely wouldn't be a complete copy of the main data source.

As an example, we'd like to use this framework to maintain a separate
reporting server. Large reports can sometimes bog down our main
database server and it would be nice to be able to run these reports
off of a separate server that's in sync with the main server. Other
uses might be to maintain an auditing database (I work in a heavily
regulated industry) or accounting database (our customers own the main
data, but we may want to maintain a separate database of what
transactions have been processed so that we can charge them based on
use).

Does MS' Data Application Block allow for multiple data sources? Others?

Scott C.
.



Relevant Pages

  • Poor security on default Windows 2000 Server installation could lead to unauthorized database access
    ... Poor security on default Windows 2000 Server installation could lead to unauthorized database access ... methods to enumerate the entire list of system DSNs on the server. ... that use DSNs to access various data sources. ...
    (NT-Bugtraq)
  • Re: Dataset with large tables
    ... good for desktop applications at all. ... scrollable server cursor because of its design. ... tables through all types of server cursors for all of data sources. ... Fast accessing all of remote data sources anywhere with SocketPro using ...
    (microsoft.public.dotnet.framework.adonet)
  • Word 2003 wont keep data sources saved on network
    ... We recently moved our files from one server to a new server (with the ... same assigned drive letter though). ... Data from your database will be placed in the document. ... the database in the "My Data Sources" directory on our local machines, ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Data Access Layer that allows Multiple Data Sources
    ... Data Access Application Block both support multiple data providers. ... > reporting server. ... > database server and it would be nice to be able to run these reports ... > Does MS' Data Application Block allow for multiple data sources? ...
    (microsoft.public.dotnet.framework.adonet)
  • Database access on a local machine
    ... I am running XP Home and have created a SQL Server database for my web site, ... FP will not display any data sources, presumably because no web server is running on my PC. ...
    (microsoft.public.frontpage.programming)