Subject | linking databases on two different machines |
---|---|
Author | nwo_2013 |
Post date | 2006-03-28T22:07:50Z |
Hi, my question is as follows...
I have machine number 1 (Windows 2003) which acts as a file and
application server for the local network, also I´ve got machine number
2 (Linux) that is used as a web server (Apache). I need to set up a web
page on machine 2, which queries a database located on machine 1.
This database is part of a program which manages inventories among
other functions and is updated by some of the network users, now I need
to make queries to this database available to customers through a web
page.
Is there a way to redirect the queries, or somehow link them between
the two machines without having to constantly replicate or synchronize
data?
I´ve found ways to redirect between two servers on the same machine but
so far I haven´t found anything that mentions two different computers.
Thanks for your help.
I have machine number 1 (Windows 2003) which acts as a file and
application server for the local network, also I´ve got machine number
2 (Linux) that is used as a web server (Apache). I need to set up a web
page on machine 2, which queries a database located on machine 1.
This database is part of a program which manages inventories among
other functions and is updated by some of the network users, now I need
to make queries to this database available to customers through a web
page.
Is there a way to redirect the queries, or somehow link them between
the two machines without having to constantly replicate or synchronize
data?
I´ve found ways to redirect between two servers on the same machine but
so far I haven´t found anything that mentions two different computers.
Thanks for your help.