Re: On DataTable, two databases

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Use a Distributed Query.

See the following articles:

http://msdn2.microsoft.com/en-us/library/aa172738(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/ms188721.aspx

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

"Steve B." <steve_beauge@xxxxxxxxxxxx> wrote in message
news:%23llsutglHHA.1244@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm building an ASP.Net corportate web application.

One module of the application consists of a web service that manages
users.
Due to the history of the organisation, there is several databases accross
the network and users data are unfortunatelly not stored in the same DB.

What I want to reach is to provides users informations (read only
informations) through the web service to hide the complexity of the data.

I've created a UsersDataTable (using the VS Designer) that have 8 columns.
Half of the columns are taken from the 1st DB (SQL Server) and the other
half columns are taken from the 2nd DB.

FYI, there is one nvarchar column in the two tables of the two sources
that identify uniquely the rows.

I want to keep the maximum of functionnalities of the VS designer and I'd
like (if possible) to avoid duplicating the data between the two sources.
I've thought about the linked server functionnalities between the two sql
server, but later, there's a probability that other platform will be
queried, in fact, I'd like a general neutral solution (pure ADO.Net).

What the best way to correctly handle the two sources ?


Thanks for your feedbacks.
Steve




.

Relevant Pages

  • Re: Challenging question
    ... use it as a stand alone db, but if you are using a Web Service, then I can't ... > SqlCe on my Handheld w/ some data downloaded onto it from Sql Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Web Service using Windows Authentication
    ... domain/login for the server. ... database access to the database your web service is using. ... >this user account in a SQL server, ...
    (microsoft.public.sqlserver.security)
  • Re: How can I start a PC program from a hand held device?
    ... There is an enormous amount of work required to get a socket server ... The only reasons you would ever want to use sockets over Web Services is for ... Create a Web Service on your server. ... Execute a stored proceedure on SQL Server (not available on SQL ...
    (microsoft.public.dotnet.framework.compactframework)
  • On DataTable, two databases
    ... One module of the application consists of a web service that manages users. ... Half of the columns are taken from the 1st DB (SQL Server) and the other ... I've thought about the linked server functionnalities between the two sql ...
    (microsoft.public.dotnet.framework.aspnet)
  • Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... identity getting propagated to the SQL server. ... Windows App is on WIN XP Pro, ... Web service on a w2K3 server, using integrated authentication, web.config ...
    (microsoft.public.dotnet.distributed_apps)