473,373 Members | 1,155 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,373 software developers and data experts.

Connecting external web application with internal database

Hi,

We have developed an ASP.NET web application and are planning to host
it in an external Server, which provides us a good bandwidht. We need
to put he web application outside because the bandwidtht that we have
in our local office won't be enough for the number of users that access
to our web app.

But for backup issues, the database server will be in our local office.

Is it possible to connect a web application hosted in an external
server with our database server in our local office?

Will performance decrease?

Is it enough to change in the web.config the conecction string?
<appSettings>
<add key="ConnectionString"
value="server=Server_At_Local_Office;database=An_O racle_DataBase;user=My_User_01;password=secret;"
/>
</appSettings>

Oct 28 '06 #1
3 3395
If the remote server can talk to the office server then you shouldn't have
any issues. Of course you will suffer some latency simply becuase of the
connection distance, but there should be little else. I often will run local
development applications against my remote live databases to ensure that
they work properly with production data. Usually there is a minimal delay
simply due to extended hops across a network, but nothing else. Of course,
some drivers may have heavier communication needs between them and the
source database and that may add extended delays, but I believe you should
be reasonably ok as most network delays I've seen are still only fractions
of a second. You'll definitely want to keep an eye on your usage of code to
ensure you are using the most efficient database methods you can in your
specific circumstances.

--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Big Charles" <ch**********@yahoo.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...
Hi,

We have developed an ASP.NET web application and are planning to host
it in an external Server, which provides us a good bandwidht. We need
to put he web application outside because the bandwidtht that we have
in our local office won't be enough for the number of users that access
to our web app.

But for backup issues, the database server will be in our local office.

Is it possible to connect a web application hosted in an external
server with our database server in our local office?

Will performance decrease?

Is it enough to change in the web.config the conecction string?
<appSettings>
<add key="ConnectionString"
value="server=Server_At_Local_Office;database=An_O racle_DataBase;user=My_User_01;password=secret;"
/>
</appSettings>

Oct 28 '06 #2
Your office network has to publish the database server on an external IP
address. Then it is a good idea to enable connecting to the published
database only from the IP address of the web server.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"Big Charles" <ch**********@yahoo.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...
Hi,

We have developed an ASP.NET web application and are planning to host
it in an external Server, which provides us a good bandwidht. We need
to put he web application outside because the bandwidtht that we have
in our local office won't be enough for the number of users that access
to our web app.

But for backup issues, the database server will be in our local office.

Is it possible to connect a web application hosted in an external
server with our database server in our local office?

Will performance decrease?

Is it enough to change in the web.config the conecction string?
<appSettings>
<add key="ConnectionString"
value="server=Server_At_Local_Office;database=An_O racle_DataBase;user=My_User_01;password=secret;"
/>
</appSettings>

Oct 29 '06 #3
Big Charles,

If your office bandwidth is already a concern, you probably don't really
want to have the database sitting at the office end of the connection,
particularly if you ever need to use SSL to preserve security.

You _will_ have performance issues as the hosted web app crosses whatever
security boundaries (firewall/DMZ) are in place between itself and your DB
location. At best this will manifest as a (tolerable?) latency/delay -
though this will be variable according to just how much bandwith is
available at that moment. At worst it will cause timeouts.

I would suggest that you keep the database as physically and logically close
to the application as possible and then implement a backup routine to pull a
copy of the DB on a regular schedule.

So long as the DB is not enormous, this can be performed without buying any
fancy software simply by using an FTP script that is run from a batch file
which is in turn called by the Scheduled Tasks (assuming you're using
Windows) - these are using basic supplied Windows features. If you're using
a standard ADSL link, this model should be reasonably efficient as you get
more speed for pulling down to the office than pushing out from the office
to the web.

If the DB grows to a larger size (>100Mb?) then you might want to consider a
different backup model - perhaps the host ISP offers a package for a small
increase in the monthly fee, or perhaps try a dedicated offsite backup
service, etc.

[ For background info, my company hosts it's own webserver, as we have a
leased-line connection. I use a separate server to host SQL server. Both
servers are behind our firewall, with appropriate rules for reaching the web
server with http and https. The various web apps use their web.configs to
store the db connection strings as you have indicated. As the servers are
both on same LAN, this virtually eliminiates any risk of DB latency.

A browser client then only needs to traverse one firewall connection (at our
end) in order to access the site/app.

BTW, I wouldn't recommend running a dev app directly against production data
as another respondee has mentioned, due to the risk of data loss or
alteration. I would export a copy of the production data to a separate Dev
instance. SQL server 2000 upwards (including the free versions) support
multiple instances on the same physical server, so you can easily have a
complete copy available for testing without posing any risk to live data and
without increasing your hardware count/expenditure. ]

Hope that helps.

Al
"Big Charles" <ch**********@yahoo.comwrote in message
news:11*********************@h48g2000cwc.googlegro ups.com...
Hi,

We have developed an ASP.NET web application and are planning to host
it in an external Server, which provides us a good bandwidht. We need
to put he web application outside because the bandwidtht that we have
in our local office won't be enough for the number of users that access
to our web app.

But for backup issues, the database server will be in our local office.

Is it possible to connect a web application hosted in an external
server with our database server in our local office?

Will performance decrease?

Is it enough to change in the web.config the conecction string?
<appSettings>
<add key="ConnectionString"
value="server=Server_At_Local_Office;database=An_O racle_DataBase;user=My_User_01;password=secret;"
/>
</appSettings>

Oct 29 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Martin_Hurst | last post by:
Is it possible to establish a connection from within a postgres database to another external database on the network, i.e., not a java or scripting connection, BUT by some type of table definition...
12
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...
7
by: Greg W via DotNetMonster.com | last post by:
hello all, I have site that I just moved to a new host. It is a dedicated server that sits behind a dedicated firewall. Most of the site uses classic ASP that are working fine but I have some...
3
by: al.cpwn | last post by:
do static and inline functions or members have internal linkage? I have been reading this newsgroup on google and found conflicting ideas. Can someone please help me understand why in some places...
3
by: Vinod R.Shenoy | last post by:
Hi All, Came across a post wherin you had helped somebody with a similar problem and was wondering if you could help us out with it. Our problem is , We have a development SQL Server 2000...
1
by: Daniel Di Vita | last post by:
I have an application that needs to pull files from an internal server. This is the setup. The web server is external facing, meaning exposed to the internet. I then have a file server that sits...
8
by: mouac01 | last post by:
I'm not sure if this is possible. I would like to have a PHP app on the Internet connect and write to a local database (Intranet). For example, users would go to a web site...
0
by: Pieter | last post by:
Hi, When using clickOnce for a VB.NET 2.0 application it installs fine on every computer, except one (a new one...). Every is isstalled, Framework, Mdac, .... The error in the log file is:...
1
by: malooga | last post by:
Hello, I'm having a problem connecting to DB2 on a remote iSeries host from a Linux server, both of which reside on my company's internal network. I'm using the IBM Linux Client V9.1. When I try...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.