Imaging a 3-tier architecture as follows:
Database ----- Application Server ----Web Server
(MSSQL) (Delphi) (PHP)
A PHP script calls functions provided by Application Server, and Application gets data from Database.
What I care most is the stability of this architecture (It should run for months continuously). Can anyone give me a suggestion about:
1: What technology should be applied for the application server to connect to database? (ODBC,BDE, ADO or any other)
2: In what way should the functions provided by application server be called? (Web Services or any other)
I would appreciate for any idea.
Thank you very much.