×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Is it Possible to use only one database on one server for 2 web sites?

Is it Possible to use only one database on one server for 2 web sites?

Is it Possible to use only one database on one server for 2 web sites?

(OP)
Is is possible to have the web site from one server interact with a database on another server?

Here is my situation:

I am running my site from two servers, mine, and then a friends. However, some people go to one, while others go to the other. This is a problem because to have access to the site, you must be authorized, and it stores your personal info on the database where only members of the site have access to it. however, one person may run a search for somone on one server, and that person's records are on the other server.

  Sincerely,
      Jim

RE: Is it Possible to use only one database on one server for 2 web sites?

You didn't mention what the database product is.  In the case of MS SQL Server, for example, it would be possible, so long as you are setup for TCP/IP protocol (not Named Pipes) and there are no firewall restrictions.

Robert Bradley
http://www.foxdev.com/
Coming Soon:
http://www.lowcostprints.com
http://www.agrainofhope.org

RE: Is it Possible to use only one database on one server for 2 web sites?

(OP)
TCP/IP through ODBC broadcast? What about MS Access?

RE: Is it Possible to use only one database on one server for 2 web sites?

If the two servers are NT and they are on the same domain, you should be able to reference the file from one server on the other.  But Access is not a database server like SQL Server or Oracle, so if the machines are not in the same domain or do not have a trusting relationship, I can't think of a way to reference the file via ODBC.

Robert Bradley
http://www.foxdev.com/
Coming Soon:
http://www.lowcostprints.com
http://www.agrainofhope.org

RE: Is it Possible to use only one database on one server for 2 web sites?

(OP)
How would I go about setting up a "trust" relationship between the two servers? My buddy (illinois) and I (north carolina) are both learning while working with all this...learning a lot - fast....but still learning.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close