klemperer
asked on
A request for suggestion to 3-tier architecture
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry I did not refresh the page....
:(
:(
>>Does Web Services developed by delphi meet my expections of stability?
Yes, also you can use Delphi .net for that
and you can also use better solution for developing web services with Delphi like RemObjects, they offer a better messaging type, but I don't know if that compatible with PHP or not
Yes, also you can use Delphi .net for that
and you can also use better solution for developing web services with Delphi like RemObjects, they offer a better messaging type, but I don't know if that compatible with PHP or not
ASKER
It was said that Delphi 6 had some bugs for Web Services implementation. I wonder whether Delphi 7 be enough for Web Services development. Thank you all.
Do you have Delphi 7 already ?
if not, then upgrade to Delphi 2005, it's fixed more bugs and contian the Delphi for .Net compiler, which you can build web services easily based on .Net
or you can buy RemObject, it's work with Delphi 6, and give you a better 3 tier architecture
if not, then upgrade to Delphi 2005, it's fixed more bugs and contian the Delphi for .Net compiler, which you can build web services easily based on .Net
or you can buy RemObject, it's work with Delphi 6, and give you a better 3 tier architecture
ASKER
Yes, I have Delphi 7 now, and have no plan to upgrade to Delphi 2000 yet.
ASKER
Does Web Services developed by delphi meet my expections of stability?