Hello Everyone and thanks for your help in advance.  I have an 
application that runs locally on my office server that accesses and 
updates a database that is not accessible to the web.  I would like to 
know if this page can also be set up to update a remote 
SQL Server database on my server?  If it can be done, how?  Any help is 
appreciated.  Thanks.

Hugh,

As long as the remote server is accessible to the machine running the page,
there should be nothing stopping it.  I'm not real clear on what your
scenario is.  You have a locally (LAN) accessible database server that the
application accesses and a remote database server?  How do you access this
remote server?  Or is that your question?

Peter

-----Original Message-----
From: Hugh McLaughlin [mailto:hugh@k...]
Sent: Saturday, January 18, 2003 02:46
To: ASP.NET
Subject: [aspx] Updating Multiple Databases


Hello Everyone and thanks for your help in advance.  I have an
application that runs locally on my office server that accesses and
updates a database that is not accessible to the web.  I would like to
know if this page can also be set up to update a remote
SQL Server database on my server?  If it can be done, how?  Any help is
appreciated.  Thanks.

Thanks for the response.  Bascially the page resides on a local server 
along with Database1.  The second database, call it Database2, resides on 
a remote server the is accessable via the Internet.  Basically, I am 
trying to update both Database1 and Database2 concurrently with the same 
data.  I suspect that this can be done, but I am not sure as to how to 
accomplish this.  Both machines are running IIS5.0, Windows 2000, and SQL 
Server.  Each machine is accessable via the Internet.  I realize I could 
run some type of replication service for th databases, but would prefer to 
proivde real-time updates.

You help is appreciated.  Thanks again.

> Hugh,

As long as the remote server is accessible to the machine running the page,
there should be nothing stopping it.  I'm not real clear on what your
scenario is.  You have a locally (LAN) accessible database server that the
application accesses and a remote database server?  How do you access this
remote server?  Or is that your question?

Peter

-----Original Message-----
From: Hugh McLaughlin [mailto:hugh@k...]
Sent: Saturday, January 18, 2003 02:46
To: ASP.NET
Subject: [aspx] Updating Multiple Databases


Hello Everyone and thanks for your help in advance.  I have an
application that runs locally on my office server that accesses and
updates a database that is not accessible to the web.  I would like to
know if this page can also be set up to update a remote
SQL Server database on my server?  If it can be done, how?  Any help is
appreciated.  Thanks.

Hugh,

The connection classes under System.Data have built in support for 
Application Level Tranactions.  This may be of benefit to you as you can 
have 2 connections to you data resources which can have processes committed 
via your guarded, handler/filter and fault blocks.

hth,
Al

>From: "Hugh McLaughlin" <hugh@k...>
>Reply-To: "ASP.NET" <aspx@p...>
>To: "ASP.NET" <aspx@p...>
>Subject: [aspx] RE: Updating Multiple Databases
>Date: Mon, 20 Jan 2003 22:38:37
>
>Thanks for the response.  Bascially the page resides on a local server
>along with Database1.  The second database, call it Database2, resides on
>a remote server the is accessable via the Internet.  Basically, I am
>trying to update both Database1 and Database2 concurrently with the same
>data.  I suspect that this can be done, but I am not sure as to how to
>accomplish this.  Both machines are running IIS5.0, Windows 2000, and SQL
>Server.  Each machine is accessable via the Internet.  I realize I could
>run some type of replication service for th databases, but would prefer to
>proivde real-time updates.
>
>You help is appreciated.  Thanks again.
>
> > Hugh,
>
>As long as the remote server is accessible to the machine running the page,
>there should be nothing stopping it.  I'm not real clear on what your
>scenario is.  You have a locally (LAN) accessible database server that the
>application accesses and a remote database server?  How do you access this
>remote server?  Or is that your question?
>
>Peter
>
>-----Original Message-----
>From: Hugh McLaughlin [mailto:hugh@k...]
>Sent: Saturday, January 18, 2003 02:46
>To: ASP.NET
>Subject: [aspx] Updating Multiple Databases
>
>
>Hello Everyone and thanks for your help in advance.  I have an
>application that runs locally on my office server that accesses and
>updates a database that is not accessible to the web.  I would like to
>know if this page can also be set up to update a remote
>SQL Server database on my server?  If it can be done, how?  Any help is
>appreciated.  Thanks.
>


_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

Hi Al,

I will take a look at the documentation for that.  Do you have any 
examples you can point me to?

Thanks for the feedback.

Hugh
> Hugh,

The connection classes under System.Data have built in support for 
Application Level Tranactions.  This may be of benefit to you as you can 
have 2 connections to you data resources which can have processes 
committed 
via your guarded, handler/filter and fault blocks.

hth,
Al

>From: "Hugh McLaughlin" <hugh@k...>
>Reply-To: "ASP.NET" <aspx@p...>
>To: "ASP.NET" <aspx@p...>
>Subject: [aspx] RE: Updating Multiple Databases
>Date: Mon, 20 Jan 2003 22:38:37
>
>Thanks for the response.  Bascially the page resides on a local server
>along with Database1.  The second database, call it Database2, resides on
>a remote server the is accessable via the Internet.  Basically, I am
>trying to update both Database1 and Database2 concurrently with the same
>data.  I suspect that this can be done, but I am not sure as to how to
>accomplish this.  Both machines are running IIS5.0, Windows 2000, and SQL
>Server.  Each machine is accessable via the Internet.  I realize I could
>run some type of replication service for th databases, but would prefer 
to
>proivde real-time updates.
>
>You help is appreciated.  Thanks again.
>
> > Hugh,
>
>As long as the remote server is accessible to the machine running the 
page,
>there should be nothing stopping it.  I'm not real clear on what your
>scenario is.  You have a locally (LAN) accessible database server that 
the
>application accesses and a remote database server?  How do you access 
this
>remote server?  Or is that your question?
>
>Peter
>
>-----Original Message-----
>From: Hugh McLaughlin [mailto:hugh@k...]
>Sent: Saturday, January 18, 2003 02:46
>To: ASP.NET
>Subject: [aspx] Updating Multiple Databases
>
>
>Hello Everyone and thanks for your help in advance.  I have an
>application that runs locally on my office server that accesses and
>updates a database that is not accessible to the web.  I would like to
>know if this page can also be set up to update a remote
>SQL Server database on my server?  If it can be done, how?  Any help is
>appreciated.  Thanks.
>


_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

Hugh,

Here is the docs with an example of using the 
System.Data.SqlClient.SqlTransaction class with 
SystemData.SqlClient.SqlConnection(): (watch for broken link)

<topic>
.NET Framework Class Library
SqlConnection.BeginTransaction Method
</topic>
<link>
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlConnectionClassBeginTrans
actionTopic.asp?frame=true
</link>

hth,
Al






>From: "Hugh McLaughlin" <hugh@k...>
>Reply-To: "ASP.NET" <aspx@p...>
>To: "ASP.NET" <aspx@p...>
>Subject: [aspx] RE: Updating Multiple Databases
>Date: Tue, 21 Jan 2003 01:28:05
>
>Hi Al,
>
>I will take a look at the documentation for that.  Do you have any
>examples you can point me to?
>
>Thanks for the feedback.
>
>Hugh
> > Hugh,
>
>The connection classes under System.Data have built in support for
>Application Level Tranactions.  This may be of benefit to you as you can
>have 2 connections to you data resources which can have processes
>committed
>via your guarded, handler/filter and fault blocks.
>
>hth,
>Al
>
> >From: "Hugh McLaughlin" <hugh@k...>
> >Reply-To: "ASP.NET" <aspx@p...>
> >To: "ASP.NET" <aspx@p...>
> >Subject: [aspx] RE: Updating Multiple Databases
> >Date: Mon, 20 Jan 2003 22:38:37
> >
> >Thanks for the response.  Bascially the page resides on a local server
> >along with Database1.  The second database, call it Database2, resides on
> >a remote server the is accessable via the Internet.  Basically, I am
> >trying to update both Database1 and Database2 concurrently with the same
> >data.  I suspect that this can be done, but I am not sure as to how to
> >accomplish this.  Both machines are running IIS5.0, Windows 2000, and SQL
> >Server.  Each machine is accessable via the Internet.  I realize I could
> >run some type of replication service for th databases, but would prefer
>to
> >proivde real-time updates.
> >
> >You help is appreciated.  Thanks again.
> >
> > > Hugh,
> >
> >As long as the remote server is accessible to the machine running the
>page,
> >there should be nothing stopping it.  I'm not real clear on what your
> >scenario is.  You have a locally (LAN) accessible database server that
>the
> >application accesses and a remote database server?  How do you access
>this
> >remote server?  Or is that your question?
> >
> >Peter
> >
> >-----Original Message-----
> >From: Hugh McLaughlin [mailto:hugh@k...]
> >Sent: Saturday, January 18, 2003 02:46
> >To: ASP.NET
> >Subject: [aspx] Updating Multiple Databases
> >
> >
> >Hello Everyone and thanks for your help in advance.  I have an
> >application that runs locally on my office server that accesses and
> >updates a database that is not accessible to the web.  I would like to
> >know if this page can also be set up to update a remote
> >SQL Server database on my server?  If it can be done, how?  Any help is
> >appreciated.  Thanks.
> >
>
>
>_________________________________________________________________
>The new MSN 8: smart spam protection and 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus

Hugh,

Depending on how "real-time" you want the updates to be, replication may
work.  I just asked our replication person, and she said that records
replicate in a matter of a few minutes.  This may not be suitable for your
situation however.

Peter

-----Original Message-----
From: Hugh McLaughlin [mailto:hugh@k...]
Sent: Monday, January 20, 2003 22:39
To: ASP.NET
Subject: [aspx] RE: Updating Multiple Databases


Thanks for the response.  Bascially the page resides on a local server
along with Database1.  The second database, call it Database2, resides on
a remote server the is accessable via the Internet.  Basically, I am
trying to update both Database1 and Database2 concurrently with the same
data.  I suspect that this can be done, but I am not sure as to how to
accomplish this.  Both machines are running IIS5.0, Windows 2000, and SQL
Server.  Each machine is accessable via the Internet.  I realize I could
run some type of replication service for th databases, but would prefer to
proivde real-time updates.

You help is appreciated.  Thanks again.

> Hugh,

As long as the remote server is accessible to the machine running the page,
there should be nothing stopping it.  I'm not real clear on what your
scenario is.  You have a locally (LAN) accessible database server that the
application accesses and a remote database server?  How do you access this
remote server?  Or is that your question?

Peter

-----Original Message-----
From: Hugh McLaughlin [mailto:hugh@k...]
Sent: Saturday, January 18, 2003 02:46
To: ASP.NET
Subject: [aspx] Updating Multiple Databases


Hello Everyone and thanks for your help in advance.  I have an
application that runs locally on my office server that accesses and
updates a database that is not accessible to the web.  I would like to
know if this page can also be set up to update a remote
SQL Server database on my server?  If it can be done, how?  Any help is
appreciated.  Thanks.