February 27, 2009 at 12:09 pm
what would be the different methods to expose a stored procedure to an external application. The external application can be another sql server 2005 or web based application or just a OS command. Our goal is to expose a stored procedure & our client would pass few parameters to this procedure & we return them a dataset.
I was wondering is there any new methods in SQL Server 2005.
Thanks
February 27, 2009 at 12:18 pm
Connect to the database using any standard method, and run the proc using the methods and properties appropriate to your programming language. Not sure what else you would do.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 27, 2009 at 1:14 pm
well! there are methods were you can expose a stored procedure using web services & so on...so i was wondering if any body used any of these features...logging on to server is easy but not a solution for remote strange users......
February 27, 2009 at 1:20 pm
Yes, you can create a layer to expose a proc through a web service. People do it all the time. It comes under the heading of building something that connects to the database, passes parameters to the proc using standard methods and properties, etc.
I could be wrong, but I don't think there's any way to tell SQL server directly to "expose this proc as a web service", nor to "expose" it any other way.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 1, 2009 at 3:32 am
RJ (2/27/2009)
what would be the different methods to expose a stored procedure to an external application. The external application can be another sql server 2005 or web based application or just a OS command. Our goal is to expose a stored procedure & our client would pass few parameters to this procedure & we return them a dataset.
Reading your post makes me think you have a backend but you do not have a frontend.
What's the architecture you are planning?... is it thin client?... three tier?... what is it?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply