Web site design

[Phils]

Hi guys;


new to asp web design;


I have design a simple web site that allows our client to login and
view reports we manage for them. this works fine as on our network as i
can connect fine to server that the database resides on for
authentication and such.


My question is what happens when the web site is hosted by hosting
company? I assume i will have to somehow point the web site back to our
live database on our network for authentication, so setting up this
connection is where my knowledge lets me down.

the only other soloution i can think of is moving the database to the
hosting server, this would mean i would have to constantly sinc the
live database on our system with the database on the hosting server
which would net be the best.

can yous point me in the correct direction guys


cheers

 

[Kevin Spencer]

Hi guy,

It sounds like you're using a file-based databasxe, such as Microsoft
Access, for your database. A file-based database is only available via file
system, which means that the file must reside on the local system, or on a
system in the same WorkSpace or Domain, so that is is available via file
pipes. A database server, such as Microsoft SQL Server, is, like a web
server, able to serve multiple clients simultaneously across a TCP network.

So, yes, if you have a web application hosted on a web server outside of
your local domain or Workspace, you would need to upload and download the
file to and from the web site to synchronize it with your local copy. On the
other hand, if the hosting service supports SQL Server, you could migrate
the database to SQL Server and use/integrate the database remotely from your
system.

--
HTH,

Kevin Spencer
Microsoft MVP
Ministry of Software Development
http://unclechutney.blogspot.com

If you have little, is that your lot?

 

[Phils]

Hi guy,

It sounds like you're using a file-based databasxe, such as Microsoft
Access, for your database. A file-based database is only available via file
system, which means that the file must reside on the local system, or on a
system in the same WorkSpace or Domain, so that is is available via file
pipes. A database server, such as Microsoft SQL Server, is, like a web
server, able to serve multiple clients simultaneously across a TCP network.

So, yes, if you have a web application hosted on a web server outside of
your local domain or Workspace, you would need to upload and download the
file to and from the web site to synchronize it with your local copy. On the
other hand, if the hosting service supports SQL Server, you could migrate
the database to SQL Server and use/integrate the database remotely from your
system.

--
HTH,

Kevin Spencer
Microsoft MVP
Ministry of Software Development
http://unclechutney.blogspot.com

If you have little, is that your lot?

Thanks Kevin for the reply,


I should have mentioned We are actualy using SQL server 2005 for the
database. so you are saying this will support web access? if so can
you give me some topics to reseach on for connection from a web host to
our database to get this working or even a typical connectiuon string
if possible.


cheers

p

 

[Kevin Spencer]

First, your SQL server has to have a public Internt IP address, or an IP
address on the same LAN or VPN as the web site. Note that security becomes a
big issue when you expose a SQL Server over the public internet. This is
certainly doable, but you must be very sharp about setting up your SQL
Server security. Using a VPN is less troublesome, if you can work this out
with your hosting service. A VPN (Virtual Private Network) is a way of
connecting to a private LAN over the WAN. I often work at my job from my
home using a VPN connection. It is also important to punch the necessary
holes in your firewall to allow traffic over the TCP port that your SQL
Server is configured to listen on.

Second, you connect to the SQL Server using a TCP connection, and the
connection string is probably much like the one you're using. There are many
examples at http://www.connectionstrings.com.

--
HTH,

Kevin Spencer
Microsoft MVP
Ministry of Software Development
http://unclechutney.blogspot.com

If you have little, is that your lot?