Subject linking databases on two different machines
Author nwo_2013
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.