webservice vs code connection string
what is the primary difference between getting data through a webservice versus getting it through a connection string in the application code?
thanks
thanks
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>#1 use for webservices
if port issues were not present, would WS be still your choice?
if port issues were not present, would WS be still your choice?
ASKER
>>you can extract whatever data you might happen to want or need.
only if appropriate permissions are given to that SQL account, right?
only if appropriate permissions are given to that SQL account, right?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>For users who are not allowed to know anything about the database, yes webservice is the way to go.
good point- thanks.
>>The downfall is network traffic.
that is true, either way, right?
good point- thanks.
>>The downfall is network traffic.
that is true, either way, right?
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.
ASKER
rg20, so what i understand you are saying is, with a DB call, it goes from DB box to App box to Client box. (in a jist). With WS, the data flows from WS to App to Client? please correct me if i am wrong..
ASKER
>>A single HTTP request response pair is probably 600 bytes too many
Would it be always more than a DB call from code?
Would it be always more than a DB call from code?
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.
ASKER
Thanks for your helpful input.
ASKER
is it equivalent of a view- selected columns only..
>>if you are calling amazon.com webservice, you will get access to only the data they want you to see, you can't get access to their gross sales.
this is how a view will do it- restrict them from the gross sales...?