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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohammed NasmanSoftware DeveloperCommented:

1. Avoid ODBC and BDE, use ADO for accessing MS Sql, or you can try direct access components like SDAC, which will give better performance.

2.   I suggest you to go with Web services, because it could be used with PHP and most of programming languages

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
klempererAuthor Commented:
Thank you for your quick answer.
Does Web Services developed by delphi meet my expections of stability?
My suggestion is ADO with Webservices
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Sorry I did not refresh the page....
Mohammed NasmanSoftware DeveloperCommented:
>>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
klempererAuthor Commented:
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.
Mohammed NasmanSoftware DeveloperCommented:
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
klempererAuthor Commented:
Yes, I have Delphi 7 now, and have no plan to upgrade to Delphi 2000 yet.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.