This is Interesting: Free Magazines for Graphics designers and webmasters
Home > Archive > Dreamweaver > November 2004 > Must database be located on same server?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Must database be located on same server?
|
|
| Sam Tous 2004-11-16, 6:53 pm |
| Can one domain (website) use the database from another website's
database? Must the database be located on the same server as the
website to query the data? Is that what a DSN-less connection is?
Best I can determine, the only way to use data from a database not
located under the same domain name (website) is to use frames? The
primary problem I have with using frames in this application is that
the search engines (as I understand it) do NOT index the data in the
frame.
Any suggestions or comments pertaining to these two scenarios? How can
I use a database which is located on a server with a differing IP
address??
| |
| Richard B. 2004-11-16, 6:53 pm |
| Haven't done it myself, but have seen references to why it shouldn't be
done. Primarily the problem calling from a different server comes when the
network is busy or delayed for some reason.
It might be more practical to export a copy of the db and table needed, then
uploading it to the server which will deliver content.
"Sam Tous" <sam_tous@yahoo.com> wrote in message
news:2fd5020c.0411141955.6ffddd05@posting.google.com...
> Can one domain (website) use the database from another website's
> database? Must the database be located on the same server as the
> website to query the data? Is that what a DSN-less connection is?
>
> Best I can determine, the only way to use data from a database not
> located under the same domain name (website) is to use frames? The
> primary problem I have with using frames in this application is that
> the search engines (as I understand it) do NOT index the data in the
> frame.
>
> Any suggestions or comments pertaining to these two scenarios? How can
> I use a database which is located on a server with a differing IP
> address??
| |
| Michael Fesser 2004-11-16, 6:53 pm |
| .oO(Sam Tous)
>Can one domain (website) use the database from another website's
>database?
Yes, in theory. In practice this is not possible in most cases. A
database on a public host should not be accessible via internet for
security reasons. Every running service on a machine, which is not
blocked by a firewall, is a security risk. That's why on most hosts a
database is only accessible by scripts running on the same machine or at
least in the host's network, access from outside should be blocked.
>Best I can determine, the only way to use data from a database not
>located under the same domain name (website) is to use frames?
Frames have nothing to do with that.
>Any suggestions or comments pertaining to these two scenarios? How can
>I use a database which is located on a server with a differing IP
>address??
Depends on how you want to use it. Do you want to use your own scripts
and queries to fetch some data from it or do you just want to call a
website on the other machine that displays some data?
Micha
| |
| Jon Spivey 2004-11-16, 6:53 pm |
| > Yes, in theory. In practice this is not possible in most cases. A
> database on a public host should not be accessible via internet for
> security reasons. Every running service on a machine, which is not
> blocked by a firewall, is a security risk. That's why on most hosts a
> database is only accessible by scripts running on the same machine or at
> least in the host's network, access from outside should be blocked.
>
A database server (eg SQL Server which obviously runs as a service) can be
accessed by IP username and password from any machine anywhere. So I can
access my SQL Servers on my host from a pc at home - it would be very
difficult to run a web site if this couldn't be done. Needless to say a web
server in say the UK could use a SQL Server in the USA.
A file based database such as MS Access is a different kettle of fish. It
would need to be on the same physical machine or accessible by unc share
from the web server. This isn't a security issue it's a limitation of
Access - in theory one can connect to access from a remote web server but
it's not a robust solution by any means.
Jon
| |
| Michael Fesser 2004-11-16, 6:53 pm |
| .oO(Jon Spivey)
>A database server (eg SQL Server which obviously runs as a service) can be
>accessed by IP username and password from any machine anywhere.
Can doesn't mean it should.
Every runnng service which is reachable from anywhere is a welcome
target for an attacker, it increases the system's vulnerability. On a
public host a firewall should block attempts to log into a database
server from outside the host's network.
>So I can
>access my SQL Servers on my host from a pc at home - it would be very
>difficult to run a web site if this couldn't be done.
Not necessary. My websites access the database on the localhost. No need
for connecting to a remote database server.
>Needless to say a web
>server in say the UK could use a SQL Server in the USA.
Sure, sometimes it might be necessary. But then I would try to increase
the security: login only from a particular IP, maybe encryption etc.
Micha
| |
| Michael Fesser 2004-11-20, 11:14 pm |
| .oO(Sam Tous)
>Can one domain (website) use the database from another website's
>database?
Yes, in theory. In practice this is not possible in most cases. A
database on a public host should not be accessible via internet for
security reasons. Every running service on a machine, which is not
blocked by a firewall, is a security risk. That's why on most hosts a
database is only accessible by scripts running on the same machine or at
least in the host's network, access from outside should be blocked.
>Best I can determine, the only way to use data from a database not
>located under the same domain name (website) is to use frames?
Frames have nothing to do with that.
>Any suggestions or comments pertaining to these two scenarios? How can
>I use a database which is located on a server with a differing IP
>address??
Depends on how you want to use it. Do you want to use your own scripts
and queries to fetch some data from it or do you just want to call a
website on the other machine that displays some data?
Micha
| |
| Jon Spivey 2004-11-21, 4:15 am |
| > Yes, in theory. In practice this is not possible in most cases. A
> database on a public host should not be accessible via internet for
> security reasons. Every running service on a machine, which is not
> blocked by a firewall, is a security risk. That's why on most hosts a
> database is only accessible by scripts running on the same machine or at
> least in the host's network, access from outside should be blocked.
>
A database server (eg SQL Server which obviously runs as a service) can be
accessed by IP username and password from any machine anywhere. So I can
access my SQL Servers on my host from a pc at home - it would be very
difficult to run a web site if this couldn't be done. Needless to say a web
server in say the UK could use a SQL Server in the USA.
A file based database such as MS Access is a different kettle of fish. It
would need to be on the same physical machine or accessible by unc share
from the web server. This isn't a security issue it's a limitation of
Access - in theory one can connect to access from a remote web server but
it's not a robust solution by any means.
Jon
| |
| Michael Fesser 2004-11-21, 4:15 am |
| .oO(Jon Spivey)
>A database server (eg SQL Server which obviously runs as a service) can be
>accessed by IP username and password from any machine anywhere.
Can doesn't mean it should.
Every runnng service which is reachable from anywhere is a welcome
target for an attacker, it increases the system's vulnerability. On a
public host a firewall should block attempts to log into a database
server from outside the host's network.
>So I can
>access my SQL Servers on my host from a pc at home - it would be very
>difficult to run a web site if this couldn't be done.
Not necessary. My websites access the database on the localhost. No need
for connecting to a remote database server.
>Needless to say a web
>server in say the UK could use a SQL Server in the USA.
Sure, sometimes it might be necessary. But then I would try to increase
the security: login only from a particular IP, maybe encryption etc.
Micha
|
|
|
| | Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |
|