Best Practice: DB Lookup or Web Service?

My application will be given an employee number. It has to query a database for the username and group memberships matching this employee. I have to use Access or MS SQL. I cannot use ADSI. Multiple applications will eventually query similar info from the same database. There will be an initial load of 5000 - 10000 queries per day. (looking at the current logged in user is cheating)

1) I can put the database inquiry direct in the application

or

2) I can design a web service to return the same information, and put the database inquiry there.

My thought is the fact that other applications will probably access the same info, better to use the service. Plus it seems cool.

Thoughts on the subject?
LVL 2
namedpipesAsked:
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.

jlachCommented:
i agree with your thoughts.. we do it differently here at my job.. all our apps query a central db, and i've also thought it to be bad ... i, in my opinion, think its better to keep all your sql in one central place (the server) and use remoting to execute methods on the server, and read the return value.. that way, if you need to change sql, you have to update the server, and not every client out on the market.. plus everything is centralized.. you dont need to worry about exposing the database to the outside world or anything like that... like i've said, using a central server seems like a better practice to me
0

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
namedpipesAuthor Commented:
Sorry.. fell asleep at the wheel... Thanks for the input - I'll accept that answer now.
0
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
C#

From novice to tech pro — start learning today.