Hello everybody,

This is my problem. I have a web based application that handles appoinments online as well as the creation of user accounts. Each time that a user creates an account, the application needs to check if the user already exists. In addition, each time that an appoinment is made, the application needs to save this data into a serverthat is different to the web server. 

Now, the two databases that contain the customer information (demographics) and other records such appointments, reside in a separate server that is actually in an office, I'll call this the "local" server. In addition, the web based application server is in a totally different location, I'll call this the "remote" server.

My question: How can my web based application in the "remote" server have access to the databases in the "local" server?

I have been reading about this in some of the MSN articles, and I have found out that I can use XML to read the database content and transfer this into the "remote" server. Is this correct? If someone could point me out to a good material (Book, article, tutorial, etc) I would greatly appreciate it.

 Thank you,

Eduardo

Are you connecting over a WAN?

I'd recommend creating a web service locally to handle connecting to the databases.  Then connect to the web service from your main app. 

I don't really know what I'm using yet. Do you know any material I can read or see to put me on track with this?

Thanks,

Eduardo

Hi EduardoAndres ,

Based on my understanding, you have one web application run at "remote" server and two databases run at "local" server. You want to visit "local" server using applicaton on "remote" server.

One common way is to use ado.net to visit databases run at different server.

You can learn it here : http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx

 And you say you want to transport data using xml . So I suggest to use WebService.

To learn it here : http://quickstarts.asp.net/QuickStartv20/webservices/doc/BPConformance.aspx

Hey,

Thank you so much for this information. Indeed, this is exactly was I was looking for. And, yes! You are correct! I want to have an application on a remote server that is going to access a local server (all information indise the database of course!)

 Agian, thanks a lot for taking the time to answer me with the correct information,

Eduardo